CODEWITHSUNDEEP
azure-logic-appsflat-file
Mark Maslar
Mark Maslar

Reputation: 1121

How to parse a flat file?

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!

Upvotes: 0

Views: 2052

Answers (1)

felixmondelo
felixmondelo

Reputation: 1474

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.

Upvotes: 1

Related Questions