Logic App: Converting CSV format table into custom delimiter column separator format

Nowadays logic apps are commonly used for data integration, especially for the Microsoft product. It allows an easy way to transport data from one system to another target system or file storage.

Most systems accept Xls or CSV file to migrate data but so is not the case in all cases. Recently I came across the requirement to separate columns with Tab delimiters. Unfortunately, there is no connector out of the box in the logic app available to convert the table and separate it with a custom delimiter.

Finally, I got a hack to achieve this target: The first step creates a CSV table with the data coming from the data source

As mentioned, we do not have any standard connector to convert with custom delimiter. We will initialize a variable connector. Then we will set a value of variable with following expression:

replace(body('Create_CSV_table'), decodeUriComponent('%2c'), decodeUriComponent('%09'))

or

replace(body('Create_CSV_table'),',','    ')

In replace function I’m taking ‘create CSV table’ as input and then replacing all the “,” with the custom delimiter required.

I hope above information shared is helpful

Do share your feedback with me
Mhq_hassan@hotmail.com