Sample Header Ad - 728x90

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