web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows remove last character ...

Power Automate - Building Flows

Answered

remove last character from csv file

(0) Share

Report

Report

Posted on by KarthikKumarstp

11

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

tom_riha 10,179 Most Valuable Professional on at

Like (0)

Report

Re: remove last character from csv file

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
Re: remove last character from csv file

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

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 614 Super User 2025 Season 2

#2

Tomac 401 Moderator

#3

chiaraalina 282

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans