AnsweredAssumed Answered

Separate text field values

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


Separate text field values


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.