If I have a CSV file..

Soldato
Joined
20 Oct 2002
Posts
18,921
Location
London
That is just one column with a list of filenames minus the extension, e.g.

File A
File B
File C

And I need to add an extension of my choice e.g.

File A.mov
File B.mov

(All extensions would be the same)
What's the easiest way of scripting this on a Windows machine? Likely to have hundreds of files in the list. One system exports the list without the extensions and we need to import the CSV into another - which needs the extensions to search properly. Extensions will almost always be .mov or .mp4 -- it'd be the same for the whole list.

Thanks!
 
The right anser is to modify the system which creates the csv so that it includes filenames.
All these other suggestions are hacks, likely requiring human involvement every time.
If it's not automated it shouldn't be done.
The first system is an Avid Media Composer which is looking at different proxies of the files (in fact the Avid media files are the 'originals' whereas the .mov are proxies). So the Avid doesn't know the .movs exist.

I like the batch file idea thanks @Simon. Can I make one of those where the user drops in the CSV and it adds .mov? That would be awesome. NB: haven't had time to look at it properly yet!
 
So, I turned up and found out they were running Macs. Woops :p

The batch file worked a treat @SimonCHere I'll file that! How easy would it be for it to add a first line as 'File Name'? :)

Sooo, for Macs then what can I use? How do you use those Python scripts @Hades ? :)
 
Back
Top Bottom