AnsweredAssumed Answered

Need text function that returns all characters left of a specified delimiter

Question asked by AndrewSleeth on Dec 12, 2014
Latest reply on Dec 12, 2014 by erawson

Title

Need text function that returns all characters left of a specified delimiter

Post

I'm having trouble finding a text function that will return all the characters (incl spaces) in a text field, starting from the left and ending with the first comma.

Ex:  In the beginning, was the word, and the word was FileMaker
        returns,  In the beginning

I need the function in order to perform auto-entry by calculation when I import records into the file using an Excel data source.  When I'm creating records during the import, Field X will auto-enter the calculation's value, taken from Field Y that's also being imported, if the value of X contains specified text (in this case, the word "Unknown").

The closest function I can find is LeftWords, but I need it to delimit the value in Field Y by a specified character (e.g., a comma) rather than the number of words from left.

-- Andrew

Outcomes