Your real file names differ from your given examples, that is not nice as we have double work to do in given the right syntax.
That is a nice list because there are the need anchors that are missing in the file names.
Can you rename all Now Foods to Now Foods# ?
And so on for all others...
But then there are digits in the names too, and the measure have one or two parts. . . . need to think some more if I have some time . ..
Or, if the files and the list are all in an correct order, you could rename with Multi-rename tool and his "
Load names from file" feature (press F10-key)
While in TC press the F1-key, and in Help search for "
Load names from file" to find "Dialog box - Multi-rename tool"
At that page find and read at:
Opens a context menu with the following options:
Load names from file: Specify a text file from which the new names should be loaded
Edit names: Save current target names to a text file, edit them, and paste back.
Configure editor: Choose a different editor to edit the files. Make sure that the editor saves as plain text!
The menu can be opened with F10.