Trim all text after character

[danm84306]

Hello,

     I am looking to trim all text after a character from a field. Example, field name operator may have multiple operators. It may show as NameA ; NameB; Name C. I only want the name in the NameA slot.

[MarcoWedel]

SubField(operator,';',1)

[stigchel · Accepted solution]

Try

SubField(Field,';',1)

[MK_QSL]

Your question don't look clear.. Can you please elaborate more with a little example along with your requirements?

[danm84306]

Thank you Marco and Piet, this worked perfectly!

[MarcoWedel]

you're welcome

regards

Marco