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