Unanswered

How to create CSV file with 'semicolon' delimiter?

(0) Share

Report

Posted on by PietroAFarias

I created a flow in which to create a CSV table based on the result of an SQL query. But, by default, the delimiter is a comma. I need to save this CSV to automate a routine, but the delimiter has to be a semicolon. How would I do that?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hi @PietroAFarias

Can you check the outputs in the TabelaCSV action?

You can add a compose action after this once and use the replace() function to replace all the commas with semi colons.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
PietroAFarias 34 on at

Like (0)

Report

I tried to do this, but it converts the array to String. Thus, I was unable to convert to an array using Array (). When I do this, everything is on the same line.
Sample output: https://i.ibb.co/qnxcxdT/Sample-POwer-Automate.png

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

Hello @PietroAFarias

Can you try the solutions from this post

https://powerusers.microsoft.com/t5/Building-Flows/Change-the-delimiter-when-creating-a-CSV-file/td-p/131894

Was this reply helpful? Yes No
PietroAFarias 34 on at

Like (0)

Report

I redid the process using Replace () because I was doing it wrong. At the end of the flow was where I used Replace (), which is the action in which a file is created, that is, after you have already converted it from Array to String.

Was this reply helpful? Yes No