I am planning the migration of a directory of image files plus a FileMaker-database containing the corresponding metadata into an Imagic IMS database
(formerly known as ImageAccess). The vendor provides a Java “Datasheet to xml conversion tool” which creates an XML file for importing image metadata from a tab-separated file. The images' filenames are made up by their image reference numbers listed in the FileMaker database.
In the source FileMaker-database the image reference numbers are often contracted, making a sample export record describing four images look something like this:
ref subject photographer 123/3-6 Building A, Living room Photographer A
For the program converting the tab separated file to XML, these four images should be listed as:
ref subject photographer 123/3 Building A, Living room Photographer A 123/4 Building A, Living room Photographer A 123/5 Building A, Living room Photographer A 123/6 Building A, Living room Photographer A
How can I best expand these contracted records into separate lines?