Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
You can separate the parts of the text field using the Part function and basing it on using the "-" as the separator
then trim to get rid of extra leading and trailing spaces.
For example and formula email field
Trim(Part([my text field], 3, "-"))
That says to get the 3rd part of the text field and then trim it.
then trim to get rid of extra leading and trailing spaces.
For example and formula email field
Trim(Part([my text field], 3, "-"))
That says to get the 3rd part of the text field and then trim it.
- JoshuaSmith6 years agoQrew TraineeThank you