now to see if I can pull the number off the name and put it in the track number field
Well, you can do that, and I'll explain, but before I do, I think there might be a better way.
If the details you are trying to parse out of [Name] already exist in the filenames (on disk) of the files, then you don't need to do it this way at all. Instead, you can have MC parse metadata out of the filenames with the Fill Properties from Filename tool. The article about this on the Wiki is a stub, but there's a link to a thread where I explain it pretty thoroughly:
http://wiki.jriver.com/index.php/Fill_Properties_from_FilenameBasically, you can tell MC to parse the details out of the filename (including, or not including, folder names as is needed) to extract the metadata tags from the file and folder naming structure. It can set a whole bunch of different tags all at once, and it automatically cleans up the values a bit too. So read that.
If you need to "split" a [Name] tag like that, and the [Track #] and real [Name] are in the filenames, it'll be easier to split them with that tool. Even if they aren't already in the filenames (they came from embedded tags) then you can still do it, by first making the filenames contain the current [Name] field with the
Rename, Move, and Copy Files tool (which
does have a good wiki article).
So, if you have a bunch of these, even if the stuff you need
isn't already in the filename, you can just "push" the current [Name] field contents into the filename somewhere (with Rename, Move, and Copy Files) and
then do Fill Properties from Filename. Based on your example, though, I suspect the stuff you need
is already in the filename.
So... That all said, you can move values from one field to another in two ways:
1. Select the files and right-click and choose
Library Tools > Move / Copy Fields. This lets you move, or copy, values in full from one field to another. Then, you can (if needed) massage those results in place.
2. Or, you can do it directly. You're editing the [Name] field and then inserting
=removeleft([Name], 4). That sets the current value of the [Name] field to the results of the expression you entered (make it "equal to" the output of this expression, hence the equals sign). But, there's no reason you have to use that to edit the [Name] field, it'll work on any field. For example, you could edit the [Comments] field and insert that same thing, and then the value from [Name] would be copied, modified, into the [Comments] field.
Or, if you wanted to copy the rightmost 2 characters from the [Name] field into the [Tract #] field, you could edit the [Track #] field and insert:
=Left([Name], 2). That would copy the leftmost 2 characters from the [Name] field into whatever field you're currently editing.
But, if you're going to do this, you should also clean it to strip out leading zeros, which might be ugly.
PadNumber() can be used for this. If you provide a digit after PadNumber() it will increase padding (add leading zeroes where needed to make it always result in the same number of digits). If you use PadNumber([Some Value], 0) it pads it to the minimum number of digits. So this would do it:
=PadNumber(Left([Name], 2), 0)That will copy the first two digits of the [Name] field over to whatever field you're currently editing, and make sure it clears any unnecessary leading zeroes.
