Variable Length String - Extract Middle Portion Multiple Delimeters

[jpstrzoch]

Greetings,

I gave a formula that returns a string value. Typical results are shown below. The variable length nature of the formula is that it has a sales representative's first and last name following the warehouse identifier.

Example: {@Burst Conditional Formula}

WHSE 101 - James Pstrzoch
WHSE 201 - Jane Doe

What I need your assistance with is creating a formula to return the first name of the sales rep. In the first example the desired result would be, "James", and in the second, "Jane".

Can you help me please?

Thank you!
James J. Pstrzoch

 

[pmax9999]

Assuming the data is consistent, the following formula will return the 1st name of the sales rep:

Split(Split({Table.Data}, ' - ')[2], ' ')[1]

Hope this helps.

Cheers
Pete