How to remove punctuation from a field

Question

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

I suggest you play with the REPLACE formula function.Thank youMarcelo Benavides Torres

markshnier__you · Answer

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

Forum Discussion

How to remove punctuation from a field

2 Replies