Removing double quotes from a text field.
I'm trying to find a way to use a formula field to remove double quotes from a text field.
So far I've tried the search and replace function and the part function, however because double quotes ar...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendya so you need to "escape" them. The escape character is a backslash. It says "Hey QuickBase what follows the backslash be treated as a regular character and not handled normally.
SearchAndReplace([My field with Quotes], "\"", "")
As an aside, it can then get tricky if you need to remove a back slash :) but there is a way double up on them.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Beautiful, that worked like a charm, thanks Mark!
------------------------------
Jordan Litwin
------------------------------
