cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gaborszollosy
Helper I
Helper I

Parse CSV error

Hello there!

 

I'd like to ask if any of you have any experience where you work with a CSV file and you get content like this:

["��i\u0000d\u0000\t\u0000c\u0000r\u0000e\u0000a\u0000t\u0000e\u0000d\u0000_\u0000t\u0000i\u0000m\u0000e\u0000\t\u0000a\u0000d\u0000_\u0000i\u0000d\u0000\t\u0000a\u0000d\u0000_\u0000n\u0000a\u0000m\u0000e\u0000\t\u0000a\u0000d\u0000s\u0000e\u0000t\u0000_\u0000i\u0000d\u0000\t\u0000a\u0000d\u0000s\u0000e\u0000t\u0000_\u0000n\u0000a\u0000m\u0000e\u0000\t\u0000c\u0000a\u0000m\u0000p\u0000a\u0000i\u0000g\u0000n\u0000_\u0000i\u0000d\u0000\t\u0000c\u0000a\u0000m\u0000p\u0000a\u0000i\u0000g\u0000n\u0000_\u0000n\u0000a\u0000m\u0000e\u0000\t\u0000f\u0000o\u0000r\u0000m\u0000_\u0000i\u0000d\u0000\t\u0000f\u0000o\u0000r\u0000m\u0000_\u0000n\u0000a\u0000m\u0000e\u0000\t\u0000i\u0000s\u0000_\u0000o\u0000r\u0000g\u0000a\u0000n\u0000i\u0000c\u0000\t\u0000p\u0000l\u0000a\u0000t\u0000f\u0000o\u0000r\u0000m\u0000\t\u0000m\u0000e\u0000l\u0000y\u0000i\u0000k\u0000_\u0000p\u0000o\u0000z\u0000�\u0000c\u0000i\u0000�\u0000r\u0000a\u0000_\u0000s\u0000z\u0000e\u0000r\u0000e\u0000t\u0000n\u0000e\u0000_\u0000j\u0000e\u0000l\u0000e\u0000n\u0000t\u0000k\u0000e\u0000z\u0000n\u0000i\u0000?\u0000\t\u0000f\u0000u\u0000l\u0000l\u0000_\u0000n\u0000a\u0000m\u0000e\u0000\t\u0000e\u0000m\u0000a\u0000i\u0000l\u0000\t\u0000p\u0000h\u0000o\u0000n\u0000e\u0000_\u0000n\u0000u\u0000m\u0000b\u0000e\u0000r\u0000","\u0000l\u0000:\u00004\u00001\u00005\u00008\u00004\u00002\u00001\u00009\u00003\u00007\u00006\u00001\u00007\u00004\u00001\u00002\u0000\t\u00002\u00000\u00002\u00001\u0000-\u00001\u00000\u0000-\u00001\u00006\u0000T\u00000\u00009\u0000

I get \u0000 before every letter, and all Hungarian characters like (áéíóöőúüű) are changed to a � symbol.

I'd like to use the compose actions to convert the data to json like in this video: https://www.youtube.com/watch?v=sXdeg_6Lr3o

But I can't get past this problem. Even replace doesn't work on removing the '\u0000' parts.

 

gaborszollosy_0-1634630270184.png

This is how my flow looks. I just want the data from the CSV to appear normally, without the � and the '\u0000' parts, and I don't know what I'm doing wrong.

I appreciate any help!

 

1 ACCEPTED SOLUTION

Accepted Solutions
tom_riha
Super User
Super User

Hello @gaborszollosy ,

I was recently dealing with the same issue, and in the end I used a workaround. Instead of the conversions I stored the .csv as a .txt file in SharePoint, and when I used 'Get file content' on the .txt file it was formatted as expected.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

View solution in original post

3 REPLIES 3
tom_riha
Super User
Super User

Hello @gaborszollosy ,

I was recently dealing with the same issue, and in the end I used a workaround. Instead of the conversions I stored the .csv as a .txt file in SharePoint, and when I used 'Get file content' on the .txt file it was formatted as expected.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

View solution in original post

Great idea, thanks! So basically if I load a csv from an attachment and create a file with it's content as .txt on SharePoint and use that for the ongoing flow, do you think it would work out?

Yes, if the .csv is a SharePoint item attachment then it's exactly the same way I used it.

image.png



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (3,423)