Removing double quotes from a text field.

Question

I'm trying to find a way to use a formula field to remove double quotes from a text field.&nbsp;
So far I've tried the search and replace function and the part function, however because double quotes are how they identify what characters you want to remove, I haven't been able to figure out a way to make this work.&nbsp;------------------------------Jordan Litwin------------------------------

markshnier__you · Answer

ya so you need to "escape" them.&nbsp; The escape character is a backslash.&nbsp; It says "Hey QuickBase what follows the backslash be treated as a regular character and not handled normally.&nbsp;&nbsp;

SearchAndReplace([My field with Quotes], "\"", "")

As an aside, it can then get tricky if you need to remove a back slash&nbsp; :) but there is a way double up on them.

------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

jordanlitwin · Answer

Beautiful, that worked like a charm, thanks Mark!------------------------------Jordan Litwin------------------------------

Forum Discussion

Removing double quotes from a text field.

2 Replies