maybe this would only appeal to a programmer or exprogrammer type but I’ve got a vast directory of random dj sets, bootlegs, etc and for instance the Artist fields have many in the form of 02_Armin_Van_Burin, 03_Armin_Van_Burin.
What’s the easiest way to select the zillions that follow this pattern to chop off the first three characters?
My first thought was like an LTrim command.
Now I also have some in the form of 03_Armin_Van_Burin 435333, 03_Armin_Van_Burin 565787950
It would be nice on those that follow this kinda of pattern to be able to select the “Armin_Van_Burin” in the center, like via a substring command…
Is there a way of doing the above and I just miss it?
(Or is the only answer going to be to export and work magic elsewhere?)