Forum Discussion

NOELHODGES's avatar
NOELHODGES
Qrew Cadet
3 years ago

How to remove punctuation from a field

how to remove punctuations from a text field .


I have fields that have commas and periods I'd like to get rid of.


Best,

Noel

------------------------------
NOEL HODGES
------------------------------
  • MarceloBenavide's avatar
    MarceloBenavide
    Qrew Cadet
    3 years ago
    I suggest you play with the REPLACE formula function.

    Thank you

    Marcelo Benavides Torres


    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      3 years ago
      ie This would be a new formula text field

      var text RemovePeriod= SearchAndReplace([my field], ".", "");
      var text RemoveComma= SeachAndReplace($RemovePeriod,",","");

      $RemoveComma

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