String till start of parens

[Former Member]

I have a column which has data like this:

1199 SEIU Benefit Funds (1199SEIU)

I would like to have the data until the (

so I would like to have

1199 SEIU Benefit Funds

I am not sure how to make this in a formula.

[former_member292966 · Accepted solution]

Split({YourField}, "(" ))[1]

This should fix your error.

Brian

[ido_millet]

Split({YourField}, "(" )[1]

[Former Member]

THis is not compiling I see an extra ( but not sure where to fix.