How can I correct the track number

[bobenilona]

Hi,

Several track numbers contain 3 digits (for example 101 or 210). How can I correct the track number? I want to delete the first number. The first number is the disk number.

Thanks!

Bob

[ohrenkino]

Use an action of the type "Format value" for TRACK
Format string: $right(%track%,2)

This leaves the 2 characters from the right end of the string.

Now: if you want to preserve the discnumber and fill the field DISCNUMBER, then you can use the following action BEFORE you apply the one I mentioned before:
Format value for DISCNUMBER
Format string: $div(%track%,100)
and right afterwards in the same action group you can use one for TRACK
Format value for TRACK
Format string: $mod(%track%,100)

The last action has the same effect as the first one with $right() - it only uses a similar mathematical function - so many routes lead to Rome.

[bobenilona]

@ohrenkino

Use an action of the type "Format value" for TRACK
Format string: $right(%track%,2)

This leaves the 2 characters from the right end of the string.

Now: if you want to preserve the discnumber and fill the field DISCNUMBER, then you can use the following action BEFORE you apply the one I mentioned before:
Format value for DISCNUMBER
Format string: $div(%track%,100)
and right afterwards in the same action group you can use one for TRACK
Format value for TRACK
Format string: $mod(%track%,100)

The last action has the same effect as the first one with $right() - it only uses a similar mathematical function - so many routes lead to Rome.

@ohrenkino

Thank you for your quick response, and it works great!!!