Lists, Loops & Variables ... Oh My!
I'm trying to rename and move comma-delimited files preparatory to importing into FMP tables. The file name is in the format ADYYMMDD.xxx and needs to be changed to xxxYYMMDD.CSV.
To get the list of files, I'm using the Scriptmaster External Function ListAllFilesRecursively( Path ).
This returns a list of paragraph separated paths in a variable.
I need to put contents of the variable into a table. Then loop through the records creating a new file name using Scriptmaster's MoveOrRenameFile ( originalPath ; newPath ) function.
So how do I get the information in the variable and read it into a table?