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

Options

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

  • Genevieve P.
    Options

    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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!