Answered

Import CSV then remove QUOTE marks

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

Trying to read in a CSV file and as part of the process, I want it to ignore any double " QUOTE marks ". There are many throughout the string and unfortunately removing them before this process is not possible.

I am using CSVParse from Encodian, so I will need to read the data through this, then remove the quotes, then use the newly QUOTE free data to be used going forward.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

You could use the replace() function to remove double quotes, for example:

replace('CSV file content','"','')

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply. This is what I was thinking of, however it's more a case of the best way to handle that, for example, I am working with the flow set below. I am not sure if it's going to work though.

I then take the "Apply To Each" and take the string and want to convert it to integer.

Was this reply helpful? Yes No
Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

The replace() function should have three parameters, we should put the original text that needs to process in the first position:

replace('<text>', '<oldText>', '<newText>')

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

How do I implant the ParseCSV data into the process though? I can only "choose" the ParseCSVData when I am using a static value, but, when you are doing a formula such as replace?

What I want to do is replace(ParseCSV,'"','"') but It comes up with some sort of formatting error,

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

Please try :

replace(outputs('Parse_CSV')?['body/csvData'],'"','')

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No