Can we remove double quotes " from a csv files via a workflow?

Walter Martinez

I have a csv files I get from a OneDrive folder, but the csv file has double quotes around the text and a comma to separate them. Is there a way to remove the double quotes on work flow before the data gets passed to another sheet? I tried the function REPLACE([Project]@row, 1, 1, ""), but this did not work. What does SmartSheet not support .xls files? that would make life a lot easier for me.

Genevieve P.

Hi @Walter Martinez

What I would do in this instance is use the SUBSTITUTE Function instead of REPLACE, as this will update any and all instances of a double quotation mark within the cell.

However for the formula to recognize the " mark, we'll want to use CHAR(34) as the code for double quote. Try this:

=SUBSTITUTE(Project@row, CHAR(34), "")

Cheers!

Genevieve