How do I read the full path to a file, & recreate path?

After renaming each new scanned pdf, I move the file from my scanned documents folder to the appropriately named folder for that file. The folder structure is complex and deep, like the roots of a tree. Many of the underlying folders are fairly ancient and no longer used.
I now want to start a new folder structure on a different drive, but I don't want to copy the entire structure, nor any of the old files.
What I want to achieve is to add a new rule, applicable to any new file that is scanned in future to the old structure, which will create the same path on the new drive.
For example, if a file's path is like this:
OneDrive/Banks/Citibank/Account 123456/statements/2018/December/Citi-1123456-statement-Dec-2018.PDF
I would like to have a rule which reads the path to the file called "Citi-1123456-statement-Dec-2018.PDF" and makes a new path on a different drive like this:
iCloud/Banks/Citibank/Account 123456/statements/2018/December/Citi-1123456-statement-Dec-2018.PDF
in other words, the OneDrive would have all the old and new files, but the iCloud drive would contain only the new files, without the redundant folder structure, except the necessary part.
So in simple terms, how do I read a file path into Hazel, and use that to create a similar file path elsewhere?
I know this must be covered already in these forums, or in the instructions. I have spent some time hunting around but couldn't seem to find the same question as below: If it has already been answered, just point me to the correct post, or cut and paste the reply here. many thanks.
I now want to start a new folder structure on a different drive, but I don't want to copy the entire structure, nor any of the old files.
What I want to achieve is to add a new rule, applicable to any new file that is scanned in future to the old structure, which will create the same path on the new drive.
For example, if a file's path is like this:
OneDrive/Banks/Citibank/Account 123456/statements/2018/December/Citi-1123456-statement-Dec-2018.PDF
I would like to have a rule which reads the path to the file called "Citi-1123456-statement-Dec-2018.PDF" and makes a new path on a different drive like this:
iCloud/Banks/Citibank/Account 123456/statements/2018/December/Citi-1123456-statement-Dec-2018.PDF
in other words, the OneDrive would have all the old and new files, but the iCloud drive would contain only the new files, without the redundant folder structure, except the necessary part.
So in simple terms, how do I read a file path into Hazel, and use that to create a similar file path elsewhere?
I know this must be covered already in these forums, or in the instructions. I have spent some time hunting around but couldn't seem to find the same question as below: If it has already been answered, just point me to the correct post, or cut and paste the reply here. many thanks.