1 Reply Latest reply on Dec 12, 2014 7:09 AM by erawson

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

    AndrewSleeth

      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