Can we remove double quotes " from a csv files via a workflow?
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.
Answers
-
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
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!