How to replace all linebreaks from an output of a csv data operation

Question

With Azure logic apps, I am taking json as an input and generating a csv output from it. There is a requirement for me to remove all the line breaks from my csv output if it looks like this:

A

B

C

D

I expect the final response to be stored in a variable as A,B,C,D. Below are all possible options I've tried, but none of them work -

Approach 1: Created a new singleReturn variable

replace(body('Create_CSV_table'),variables('var_newLine'),',')

Approach 2:

replace(body('Create_CSV_table'),decodeUriComponent('%0A'),',')

Answer 1

Hi Vivek Komarla Bhaskar

Thanks for reaching out on Microsoft Q&A!

Your plan of attack seems correct, however I do believe that the place where you're replacing the text is where it is going wrong. I think you should already remove the new line feed in the JSON, and push that to the CSV as input, kinda like this:

json(replace(string(body('YOUR_JSON_ACTION')),variables('``var_newLine``'),','))

Please click ‘Accept answer’ if you think my answer is helpful. Feel free to drop additional queries in the comments below!

Kind regards,

Sonny