Trim a field based on characters

evansabres — Wed, 10 Jun 2020 13:52:11 GMT

I have a field, NAME which has data that appears as Brand-10102019-Campaign. I want to trim this field in my script to only return the 'Brand' portion of the string. The Brand portion is not a set number of characters so doing left, 5 would not work. How can I achieve an end result of 'Brand' from the string 'Brand-10102019-Campaign'

Re: Trim a field based on characters

agigliotti — Wed, 10 Jun 2020 13:54:46 GMT

Hi,
if you always have the "-" symbol as delimiter you can do as below:

=Subfield( string, '-', 1 )

I hope it can helps.

topic Trim a field based on characters in App Development

Trim a field based on characters

Re: Trim a field based on characters