spookytooth

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))

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