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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!