Hi, I need to rename external files (image files) based on the field value of FMP database.

Say I have a DB with following structure.

FilePath(Text) FileName(Text) NewFileName(Calculated=Style, Text), Style(Text)

-------------------------------------------------------------------------

C:samples a.jpg fancy_pants.jpg fancy_pants

I am guessing that I might have to use DDE command from script.

For Example, "rename a.jpg fancy_pants.jpg"

Has anyone done this or perhaps point to a right direction?

Thanks in advance!

Many Thanks

Since I work on a Mac, I'm a bit hazy here, but I think you can use the Send Message script step to execute the rename command. You can make a calculated field to hold the actual command text like this:

CommandText = "rename "& OldFilename & " " & NewFileName

where OldFileName and NewFileName are fields containing the names.

Then set up your Send message step to use the contents of field CommandText.