How to parse a flat file?

Question

In an Azure Logic App, how can I parse a fixed-position flat file? The file arrives via FTP. It's a fixed-position ASCII file. E.G. Field 1 is always column 1 through 18. Field 2 is always column 19 through 55. etc. My Logic App begins with the FTP When A File Is Added Or Modified connector. Then I do a Get File Content connector.

Next, I envision iterating through each record (new line delimited) and mapping fields to some new data structure.

Is there an easy way to do this? Should I write an Azure Function App?

Thanks!

Answer 1

You can use Integration Account and Flat File Schemas, decode/parse the incoming flat file message with the Flat File Decode component and mapping to a new data structure with a Integration Account Map and the Transform XML component.