remove last character from csv file

(0) Share

Report

Posted on by KarthikKumarstp

Hello,

My CSV file has a unwanted comma at the end of each row which creates additional column in my subsequent process

Here is the sample data

Heading 1, Heading 2, Heading 3

1,2,3,

4,5,6,

7,8,9,

As you can see in the above example, I have 3 rows with one header. My value rows have comma at the end of each row which need to be trimmed. I tried but couldn't find a better way.

I tried the data operations in MS flow but couldn't get it all done

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @KarthikKumarstp ,

since it's a csv, I guess you're using split(...) by the end of the line character to split it into separate rows. Why don't you just add the comma to the split(...), instead of just the end of a line you can split it by comma and the end of the line (and then somehow remove the header).

Was this reply helpful? Yes No
Verified answer

KarthikKumarstp 11 on at

Like (1)

Report
Thanks for the response.. I finally accomplished this by simple replace function.

Here is what I did

Initialized two variables - one with comma and hard return and another with just hard return
Using replace function replaced variable 1 with variable 2
replace(outputs('CSVtoString'),variables('var_newlinew_comma'),variables('var_newline'))

Was this reply helpful? Yes No