how to change csv delimiter

(0) Share

Report

Posted on by JACK_LAI_1117

267

HI All:

I used this method to get csv content

the content like below

"Display Name,Asset Type,Description,Asset Tag,Impact,Used By,Department,Managed By,Assigned On,Location,Managed By Group,Used by (Name),Managed by (Name)
"MSI TridentX 10TE-1435( I9-10900K,DDR432G,SSD-1TB)",Desktop,"7F ~ ADM202106005 ~ AAAA,20210609 2021/06/26 : transfer to XYZ",610839-11,Low,USERA-test@aaa.com,IT Deptment (410),"",2021-06-24 00:00:00,QWER,"",USERA-test,"

then I use " split(items('set-result-array-B-value'), ',') " to insert string to my array

Now I have problem !!!!

Because in some csv column content , user had keyin "," in the column , so when I to get some info from Compose-A , it will show error message , So could I change the delimiter like " ^" then split my string ???

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

manuelstgomes 6,625 on at

Like (0)

Report

Hi @JACK_LAI_1117

Parsing CSV files is tricky. I created a template to do it and explain the steps here:

https://manueltgomes.com/microsoft/powerautomate/parse-a-csv-new-template/

I also have another article that explains how I made the first version of the template.

https://manueltgomes.com/microsoft/powerautomate/how-to-parse-csv-file/

You can download it, import it in your instance and use it as a "black box" to get the information you need.

Can you please check if this is what you need?

Cheers

Manuel

------------------------------------------------------------------

If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. ?

Otherwise, reply to it, and the community will do its best to help you.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

@JACK_LAI_1117

Here is a template that just changes the delimiter. And it should work in about 1 second even for large files.

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Change-CSV-Data-Delimiter/td-p/1442954

Was this reply helpful? Yes No