How to change delimiter from "," to ";" in a csv file

(1) Share

Report

Posted on by SP-04030758-0

Hi everyone !

I've a CSV file on a sharepoint folder and i need to change the delimiter to ";".

I've read a lot of post but all of them needs a SharepointList or a premium account, none of them are free... Do you have any solution ?

BR,

Séb'.

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Chriddle 8,708 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Why?

Was this reply helpful? Yes No
SP-04030758-0 14 on at

Like
a
(0)

Report
Copy link

Link copied!

@chriddle , because my boss ask me...

Our client can't change his output and we're in trouble with the delimiter, so it appears the solution is to change the delimiter isnt it ?

BR,

Séb'.

Was this reply helpful? Yes No
Chriddle 8,708 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
I wonder what the trouble could be.

Is it just opening the file with Excel? Then there is no delimiter change needed.

This can be solved with sep=, in the first line (easy to implement with a flow).

How to Open CSV with Delimiter in Excel (6 Methods) (see Method 3)

If you really have to change the delimiter you can go the easy way and just do a string replace (This will fail - or rather result in an invalid CSV file - if your CSV file contains commas or semicolons within the values.):
replace(<your CSV>, ',', ';')

If I needed an absolutely foolproof solution, I would probably code it in a custom connector.

Was this reply helpful? Yes No
SP-04030758-0 14 on at

Like
a
(0)

Report
Copy link

Link copied!

The problem is my boss dont want to manipulate the file with excel because we receive a lot of file every day..

The solution with "Replace" doesnt work because i have some "," in my file and I dont want to replace them.

When you say you would probably code a custom connector, what does that means ?

Was this reply helpful? Yes No
Chriddle 8,708 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The problem is my boss dont want to manipulate the file with excel because we receive a lot of file every day..

Simply add a line with "sep=", to the top of the CSV file.

Check the link in my previous post.

Was this reply helpful? Yes No
SP-04030758-0 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry but i don't find any solution without using excel in your link...

Was this reply helpful? Yes No
Chriddle 8,708 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Or ask him to change the default separator on his computer.
https://credlyissuer.zendesk.com/hc/en-us/articles/30755129481755-How-to-save-an-excel-file-as-a-comma-delimited-CSV

Was this reply helpful? Yes No
Chriddle 8,708 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry but i don't find any solution without using excel in your link

How to Open CSV with Delimiter in Excel (6 Methods)

Was this reply helpful? Yes No
SP-04030758-0 14 on at

Like
a
(0)

Report
Copy link

Link copied!

ep', i saw this one but i dont understand how to add it to my csv, do you have any trick ?

BR,

Séb'.

Was this reply helpful? Yes No
Suggested answer

Chriddle 8,708 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Just a Compose like this

Insert the delimiter line and below it the content of the CSV file. Save this to a file.

Was this reply helpful? Yes No