Skip to Content
avatar image
Former Member

String till start of parens

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 15 at 11:23 PM

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

    This should fix your error.

    Brian

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 30 at 10:58 PM

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

    Add comment
    10|10000 characters needed characters exceeded