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
The arguments for the Part function are all the delimiter characters you want to trap.  So you can do this



Part([Project Name],1," !@#$%^&*';:?/><")
But, I don't know how to trap a quote  ".  I will do a quick test now to see if a "" will do it.