Skip to main content
Question

Removing double quotes from a text field.

  • July 21, 2023
  • 0 replies
  • 341 views

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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • July 21, 2023

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

    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement