Is there a way to remove the text along with the - that comes with it, in a query I was given information on how to copy all the text to the correct field and have managed to work out how to remove just the text without the numbers too.
Your code above moves the artist name to the correct box and someone else showed me a way of duplicating the artist to the album artist, just not how to remove the artist from the filename.
In a nutshell I'm trying to create the same type of format that we used to get when ripping cds.
There are at least two ways to accomplish this: a) You can use the Convert menu in the GUI. The advantage is the immediately view of the preview result before you apply it to the selected songs
or b) You can use an Action as ohrenkino showed you in his answer