I have a database listing all my old, physical-media music. At the time I created it, instead of creating a media-type field, I just used the comments field to indicate if it was something other than vinyl. Now I've created a media-type field and I'd like to find an easy way to populate it. If the comments field contains "(T-" then it's a reel-to-reel tape (ID 4). "(c)" makes it a casette (ID 3). CD, of course, means it's a CD (ID 2). And if it's none of those, then it's vinyl (ID 1).
This isn't an ongoing issue, I just need something to set the media-types in one fell swoop and then in future I'll just set it manually for anything I add. Is there a way to do this via macro?