Need text function that returns all characters left of a specified delimiter
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.
Left ( field ; Position ( field ; "," ; 1 ; 1 ) - 1 )