Trim a field based on characters

[evansabres]

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'

[agigliotti · Accepted solution]

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

=Subfield( string, '-', 1 )

I hope it can helps.