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 --------------...
Forum Discussion
I suggest you play with the REPLACE formula function.
Thank you
Marcelo Benavides Torres
- MarkShnier__You
Qrew Legend
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
------------------------------
