convert SWIFT message to XML file (or) flat file
Posted: Fri Aug 08, 2008 12:04 pm
hi
please can any one help me.
i got a task to convert a SWIFT message and this SWIFT message should be convert into the flat file (or) XML file. this XML file (or) flat file i got to use it in datastage parallel for my job.
the SWIFT message, we'd like to reformat it to a pipe delimited file too.
The end result should be a pipe delimited file with column heading (use each tag for now).
The value for each row,:
Repeat the values in {1:} and {2},
Repeat values for all tags except tag :61:.
The only difference in each row is the value in tag :61:
It's ":<tag>:<value >". The tags for each kind of message are SWIFT standard
the SWIFT message look like
for ex:
{1:F01BOFAUSNYJXXX4321000123}{2:I103BANKDEFFAXXXN2 020}{3:{103:CAD}}{4:
:20:NY20040126000111
:23B:CRED
:32A:040116USD1000000,00
:50K:/987654321
Big Deal Real Estate
Madison Avenue
New York, NY USA
:57A:/654321
NOSCATTT
:59:/1234567890123
I. Buy Buildings
200 Front Street
Toronto, Ontario
Canada
:70:re real estate purchase
10000 King Street East
Toronto
:71A:OUR
-}{5:{MAC:23456789}{PAC:23456789}{CHK:123456789012} {SYS:1231313}{TNG:}{PDE:12345}{DLM:}}
thanks
![Sad :(](./images/smilies/icon_sad.gif)
please can any one help me.
i got a task to convert a SWIFT message and this SWIFT message should be convert into the flat file (or) XML file. this XML file (or) flat file i got to use it in datastage parallel for my job.
the SWIFT message, we'd like to reformat it to a pipe delimited file too.
The end result should be a pipe delimited file with column heading (use each tag for now).
The value for each row,:
Repeat the values in {1:} and {2},
Repeat values for all tags except tag :61:.
The only difference in each row is the value in tag :61:
It's ":<tag>:<value >". The tags for each kind of message are SWIFT standard
the SWIFT message look like
for ex:
{1:F01BOFAUSNYJXXX4321000123}{2:I103BANKDEFFAXXXN2 020}{3:{103:CAD}}{4:
:20:NY20040126000111
:23B:CRED
:32A:040116USD1000000,00
:50K:/987654321
Big Deal Real Estate
Madison Avenue
New York, NY USA
:57A:/654321
NOSCATTT
:59:/1234567890123
I. Buy Buildings
200 Front Street
Toronto, Ontario
Canada
:70:re real estate purchase
10000 King Street East
Toronto
:71A:OUR
-}{5:{MAC:23456789}{PAC:23456789}{CHK:123456789012} {SYS:1231313}{TNG:}{PDE:12345}{DLM:}}
thanks
![Sad :(](./images/smilies/icon_sad.gif)