In the firm I work for, they have file naming system. It always has 5 sections as in the examples below:
File Name: YYMMDD_PROJECT NUMBER_PROJECT NAME_FILE NAME_initials.ext
140527_207_AL MURR VILLA_INFO_ne.doc 140527_207_AL MURR VILLA_MAIN ENTRANCE_ne.jpg 140527_207_AL MURR VILLA_PROPOSED SECTION EAST VIEW_ne.jpg
In my indesign, I am working with hundreds of projects images. Instead of writing the titles of the image, I want to grab this from the file name itself. I use Insert Variables/ Image name. It works but it grabs all the file name including the extension as well. What I want to do is to get only the fourth section from the file name above. It always comes after the third underscore and before the fourth one.
I'm not sure if it's doable or not, since it has multiple underscores in it. I thought I better ask the experts.
Thanks in advance.