I have a large number of file that need to be renamed
Original Format = SC-SZ-1234
New Format = SC-NW-1234
How do I use the import/export tool to do this and where can I find a step by step tutorial
This can be done with PW E/I, but I doubt you'll find any kind of a tutorial.
Rename exported files (so the import process finds them)
Update the spreadsheet to reflect the new names and field values (such as name and potentially others)
ImportEnable update files
I'd recommend having a single test file to practice with. PW E/I is very particular, and the last thing you want is to get an error in the middle of a large process.