Expanding contractions/number ranges into separate records
1
vote
1
answer
127
views
I am planning the migration of a directory of image files plus a FileMaker-database containing the corresponding metadata into an [Imagic IMS](http://www.imagic.ch/index.php?id=99&L=2) 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?
Asked by Oliver
(19 rep)
Sep 25, 2012, 03:24 PM
Last activity: Nov 14, 2015, 08:00 PM
Last activity: Nov 14, 2015, 08:00 PM