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
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.