cancel
Showing results for 
Search instead for 
Did you mean: 

EXTRACTING DATA FORM SWIFT MT103

Former Member
0 Kudos

Hi, I have a Swift format for Mt103 , how can we extract data form this format and store it into Sql table.

note that the fields that we should extract :20: , :23B: , :50K: ...etc

thanks in advance

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member200473
Contributor
0 Kudos

could you please provide more information on your source file data, file structure and target(expected output ) structure and data.

Shiva Sahu

Former Member
0 Kudos

Hi, thanks for your reply

My source file is the attached file, and I want to extract the fields from this file, the file contain many fields encoded as follow ":XXX:"  which XXX is 20, 23B, 50K , 59 Etc, and the target is a table with columns regarding to theose fields, each source file should produce one record in the table, but in the record I should place the informations in the right columns (fields).

thanks