Answered

Import CSV then remove QUOTE marks

(0) Share

Report

Posted on by Community Power Pla...

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 on at

Like (0)

Report
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... on at

Like (0)

Report

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 on at

Like (0)

Report

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... on at

Like (0)

Report

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 on at

Like (0)

Report
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