AnsweredAssumed Answered

Separate text field values

Question asked by dlh27 on Jul 3, 2012
Latest reply on Jul 3, 2012 by Abhaya

Title

Separate text field values

Post

Hoping FMPro can solve a problem.  I've successfully concatenated text fields, but now I need to separate a field (or whatever the opposite of concatenate is).  I have  a column which contains values consisting of one or more words and an expression that begins with a "#".  For Example - Soccer Complex #01.

I've successfully used the "Right" function to extract the "#" expression.

I can't figure out how to isolate the beginning of the expression.  There isn't a consistent number of letters or words to work with.  There are 4 possible values that appear before the "#":

UT Dallas

Moss Park

Toyota of Lewisville - Railroad Park

Chinn Chapel

Any help would be appreciated.

Outcomes