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
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!