Mac utility needed to rename files from a spreadsheet.

Job ID: 34181300

Budget: $30 – $250 USD

Mac utility needed to rename files from a spreadsheet.

If the [Answer] starts with a number, rename the file:
[Clip ID] QQ_[Category];; [Question]_[Answer]_[Answer]

If the [Answer] starts with a letter, rename the file:
[Clip ID] QQ_[Category];; [Question]_[SingleLetterAnswer]_[Answer]

NOTES:

[SingleLetterAnswer] is just the first letter of [Answer]

When renaming the files, you must replace any text containing the following characters.
? Should be replaced with ^^
" Should be replaced with ''
: Should be replaced with ;;
* Should be replaced with ++
/ Should be replaced with {{
\ Should be replaced with }}
< Should be replaced with [[
> Should be replaced with ]]
Related categories: Mac OS