Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Remove commas from csv file

(0) ShareShare
ReportReport
Posted on by 402

Good morning! We have a power automate procedure that parses incoming csv files.  Recently one of the jobs errored out and it was found that some of the street address data contains a comma.  These file fields are NOT delimited with double quotes, but are separated by comma and then parsed at the line break.  Is there a way to remove commas in the field data without harming the commas that are delimiters?

 

Thanks for the information

  • ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Remove commas from csv file

    @iskguy 

    It would be very difficult to impossible to do what you have asked.

    Here is an alternative.  You should know how many commas should be in each row.  Find out how many commas are there and compare to what should be there.  If the numbers don't match, write the row of data off to an error log somewhere and then move onto the next row.

    To check the number of commas, you might use a split expression - the number of commas will be one less than the number of elements in the array produced by split()

    image.pngimage.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard