How to "read" a SWIFT message?

c# banking swift-mt
Michael Bruyninckx picture Michael Bruyninckx · Jan 17, 2013 · Viewed 10.3k times · Source

"SWIFT" meaning Society for Worldwide Interbank Financial Telecommunication

I need to read some files and insert the data in a SQL Server database table using C#.NET. The files are downloaded from a banking software (ABN Amro), and they contain (debit & credit) movements on the account.

It contains a lot of :61: and :86: "tags", it seems almost human readable, but it's not, especially when they're talking amounts, it's impossible to filter those out if you don't have the correct specs.

I'm searching like crazy but I can't find enough information, I mean a document that explains how to interprete these messages/files? Not even on swiftcommunity.net... or maybe I'm not looking on the right spot.

Does that exists, and where?

Answer

Filip De Vos picture Filip De Vos · Jan 17, 2013

The Swift mt940 file format has a header line, a footer line, some mandatory lines with information and then a bunch of lines meaning transactions. The lines start with a :XX: code to indicate what type of line it is.

If you google you can find the spec quite easy from a number of banks. for example:

Related questions

How do I generate a random int number?

How do I generate a random integer in C#?

Read More
Regular expression to check if password is "8 characters including 1 uppercase letter, 1 special character, alphanumeric characters"

I want a regular expression to check that a password must be eight characters including one uppercase letter, one special character and alphanumeric characters. And here is my validation expression which is for eight characters including one uppercase letter, one …

Read More
How to make an HTTP POST web request

Canonical How can I make an HTTP request and send some data using the POST method? I can do a GET request, but I have no idea of how to make a POST request.

Read More