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 "#":
Toyota of Lewisville - Railroad Park
Any help would be appreciated.