Forum Discussion

JasonPhenicie's avatar
JasonPhenicie
Qrew Trainee
9 years ago

Remove disallowed characters from a text field

Our app has a [Project Name] field in which our users can input whatever project name they like. We then have a [Project ID] field that uses 9 Part([Project Name],1," ") formulas to combine the first ...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
This seemed to work to trap a quote.  the backslash acts as as an escape character.  But next  you will be wanting to trap the backslash too!  I think that you use a double \ to do that.

Part([Part entry],1,"\";@#$\\/")