AnsweredAssumed Answered

Selecting a portion of field

Question asked by john.s on Jan 14, 2016
Latest reply on Jan 18, 2016 by Mike_Mitchell

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.