Mac utility needed to rename files from a spreadsheet.
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 ]]
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