8 Replies Latest reply on Jan 18, 2016 4:19 AM by Mike_Mitchell

    Selecting a portion of field


      I have a container with a .jpg image and a field that pulls the file name.  I want to export a file containing a portion of the file name but am having some problems.

      File name format is 2 digit code i.e. A1, A2, B1, B2

                                      Title (could be a few words) followed by a comma

                                      Photographer Name

                                      File Extension


      Example:   A2 Some Winter Day, John Smith.jpg

      I want a field that I can export containing everything up to the comma but can't find the right combination of Functions to pull just that portion.

      Any help will be greatly appreciated.