I should have given a bit more detail about what I'm trying to do.
I've got about 10,000 files in FLAC format which I also have mirrored in Apple Lossless (M4A) format. So 20,000 files in total.
If I use squeezebox to assign a rating to a track in FLAC then I also want to have the equivalent Apple Lossless file be given the same rating.
If Bon Jovi - Living on a Prayer.flac has a rating of 3; then I want Bon Jovi - Living on a Prayer.m4a to be given that same rating.
I hoped that I could simply have an Action > Format Value which went something like this (in pseudo code):
If File is a M4a then
if the FLAC equivalent of that file's rating <> 0 then the M4A file's rating = the FLAC file's rating.
As an example:
If "Bon Jovi - Living on a Prayer.flac"'s Rating <> 0 then "Bon Jovi - Living on a Prayer.m4a"'s rating = "Bon Jovi - Living on a Prayer.flac"'s Rating
Given that the file name is always going to be the same (but just a different file type) I thought I could use some basic string manipulation functions (e.g. convert a .m4a filename to a .flac file name by subtracting 3 characters from the length of the string and add "flac") to look up the relevant file's rating.
Is this possible? Or do I have to use a script? If so, I've never done a script before - how would I do it?