Forum Discussion

JordanLitwin's avatar
JordanLitwin
Qrew Member
11 months ago

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 are how they identify what characters you want to remove, I haven't been able to figure out a way to make this work. 



------------------------------
Jordan Litwin
------------------------------

2 Replies

  • ya 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
    ------------------------------

    • JordanLitwin's avatar
      JordanLitwin
      Qrew Member

      Beautiful, that worked like a charm, thanks Mark!



      ------------------------------
      Jordan Litwin
      ------------------------------