I am creating a simple database designed to be used with a CGI/Perl script. The idea is that I can export all of the relevant field data into a text file in the format required by the CGI script. This is all working great. simple, lovin it!! Now, I have tried parsing the name of the image within my container field a number of ways. The most successful method to date is using the folowing:

"/"&RightWords ( northwest_catalog_2005::Image_Thumb ; 3)

This works fine if the name of the file is "image_spongebob/pillow110.gif"

However, if the name is "image_spongebob/110pillow.gif", then the required parsing method changes to this:

"/"&RightWords ( northwest_catalog_2005::Image_Thumb ; 4)

Since I don't have the luxury of changing all of the image file names, I don't feel this method is appropriate.

With that in mind, I have also tried the following,

Get(ActiveFieldContents)

Which yields too much info such as:

size:210,175

image:../cmn/image_sponge/pillow110.gif

imagemac:/Pallas/Documents/ Walter_Folder/CMN/Web/cmn/image_sponge/pillow110.gif

All I need is the filename.gif and the parent directory info:

/image_spongebob/filename.gif

Any ideas on parsing this out for the best result? All ideas are appreciated.

Mike

This works, although I'm not totally clear on how. It just happened while I was having fun.

"/" & Right(northwest_catalog_2005::Image_Thumb;Length(northwest_catalog_2005::Image_Thumb) - Position(northwest_catalog_2005::Image_Thumb;"/image_";Length(northwest_catalog_2005::Image_Thumb);-1))