I have some questions for my workflow, but since there are several tools/features involved I have chosen one single topic title to cover them all.
1) I want to rename and move files based on their filenames
File Name Variations:
- "qwerty - asdf.ext"
- "qwerty abc - asdf.ext"
- "qwerty def - asdf.ext"
- "qwerty xyz - asdf.ext"
Now, all files starting with "qwerty" should be moved to a subfolder named "qwerty"
Results:
- "qwerty\qwerty - asdf.ext"
- "qwerty\qwerty abc - asdf.ext"
- "qwerty\qwerty def - asdf.ext"
- "qwerty\qwerty xyz - asdf.ext"
will be moved to "FILENAME_PART1\FILENAME_PART1 [OPTIONAL_TEXT] - FILENAME_PART2"
2) Create custom columns where each column is a part of the filename
File Name: "blah _ qwerty - asdf.ext"
Columns: "blah" | "qwerty" | "asdf"
or at least: "blah" | "qwerty - asdf"
Here the main separator is an underscore "_" whereas the (optional) secondary separator should be a dash "-"
Can this be done?