Moving files based on name

Hi,
I really hope someone might be able to help me.
I've recently started working as a freelance audio producer.
I get a lot of file names, based on the order number.
Something could look like
123456-Produced.mp3
123456-Dry.mp3
Or
654321-001-Produced.mp3
654321-002-Produced.mp3
654321-003-Produced.mp3
654321-001-Dry.mp3
654321-002-Dry.mp3
654321-003-Dry.mp3
aka "order number - cut number (if one) - type .File extension"
Basically, right now I save all my files in a "final cuts" folder.
I work out of a sessions nested folder system, where I drop all the audio needed along with its sessions file. These session folders are named the same as the order number aka "654321" or just "123456"
But for workflow reasons, I don't want to save these files into each session folder, until its time to archive.
Since I need to save them to a shared dropbox "completed orders" folder, before archiving
What I would LOVE to do is:
A) Run hazel to move all the files "Dropbox>Final Cuts" to "Dropbox>Sessions>(Folder based on the first 6 digits of the file name)
and if possible
B) First have Hazel copy the same files from "Dropbox>Final Cuts" to "Dropbox>Completed orders>(Folder name based on its first six digits) But the folder would need to be created in this instance.
I hope this makes sense?
Can anyone help me out? I think I say a few posts about "Matching" but I am so new to this. Is there a way to check just a portion of the file name? and we go through numbers so quickly, its rare to have an order in sequential order.
Im sure I'll catch on once I can play with this a bit. Thanks!
*EDIT*
Even if someone would lead me in the right direction with a keyword or something...
I feel like I cam trying to accomplish something advanced, on my first try.
Thanks
I really hope someone might be able to help me.
I've recently started working as a freelance audio producer.
I get a lot of file names, based on the order number.
Something could look like
123456-Produced.mp3
123456-Dry.mp3
Or
654321-001-Produced.mp3
654321-002-Produced.mp3
654321-003-Produced.mp3
654321-001-Dry.mp3
654321-002-Dry.mp3
654321-003-Dry.mp3
aka "order number - cut number (if one) - type .File extension"
Basically, right now I save all my files in a "final cuts" folder.
I work out of a sessions nested folder system, where I drop all the audio needed along with its sessions file. These session folders are named the same as the order number aka "654321" or just "123456"
But for workflow reasons, I don't want to save these files into each session folder, until its time to archive.
Since I need to save them to a shared dropbox "completed orders" folder, before archiving
What I would LOVE to do is:
A) Run hazel to move all the files "Dropbox>Final Cuts" to "Dropbox>Sessions>(Folder based on the first 6 digits of the file name)
and if possible
B) First have Hazel copy the same files from "Dropbox>Final Cuts" to "Dropbox>Completed orders>(Folder name based on its first six digits) But the folder would need to be created in this instance.
I hope this makes sense?
Can anyone help me out? I think I say a few posts about "Matching" but I am so new to this. Is there a way to check just a portion of the file name? and we go through numbers so quickly, its rare to have an order in sequential order.
Im sure I'll catch on once I can play with this a bit. Thanks!
*EDIT*
Even if someone would lead me in the right direction with a keyword or something...
I feel like I cam trying to accomplish something advanced, on my first try.
Thanks