Writing an export contents script for all records, but what about different extensions?

[JTSmith]

I can write a script that goes through each record and exports all the containers, but not all of my containers have the same file type. Is there a way to make it just either export the original file name, or preserve the extension?

I have 15 containers per record, and I would prefer to name them "1.original extension", "2.original extension", etc. Is that possible?

Thanks!

[comment]

Do all your container fields contain the original extension? You can check this by looking at the result of =

GetAsText ( YourContainerField )

If the answer is yes, you can parse out the original extension from there and use it in the export.

I have 15 containers per record

That doesn't sound like the best arrangement; why not keep them as separate records of a related table?

[JTSmith]

Thanks! Yes, they have the original extension, and I will figure out how to parse after the period. I'm not an expert on parsing, but that part I should be able to figure out. Thank you for the help (again). I do have a table of Property Images, which is where they are stored.

[JTSmith]

OK, I lied, I can't figure it out... Can you help me to parse everything after the period?

[comment]

If all your files have a three-letter extension, it could be as simple as =

Right ( FileName ; 3 )

(or 4, to include the period). Otherwise, try =

Let (

len = Length ( FileName )

;

Right ( FileName ; len - Position ( FileName ; "." ; len ;  -1 ) )

)

[JTSmith]

Thanks, I did figure out the first option, but some extensions were JPEG, so I couldn't figure out the period. No I got it, thanks a lot.