Deleting end characters
I'm having difficulty trying to strip out the middle of a text string. Below is an example of the record as it is entered into Quickbase in the field [Name]: [NYC OM] On Model - Standard - /1022201...
Forum Discussion
Try this
var text StepOne = NotLeft(Trim([Name]),"/");
IF(Ends($StepOne, "/"), NotRight($StepOne,1), $StepOne)
var text StepOne = NotLeft(Trim([Name]),"/");
IF(Ends($StepOne, "/"), NotRight($StepOne,1), $StepOne)
- Perfect! Thank you
