Remove a, an and the

Support
1

I want to create an action to remove a, an and the from the beginning of a string, how would I code that. Have spent hours researching and experimenting but can't get it done.

Any help would be appreciated. explaining what each part is doing would go a long way in helping me understand the coding better. If that is to much to ask it's fine, I can always dissect the correct code later

Thank You much

2

Create an action of the type "Replace with regular expression" for the field with the string (you don't say which it would be)

Search string: ^A |The |An
Replace with:
(leave empty)

For more details about regular expressions, see the documentation:

I, for myself have abandoned the idea to remove the articles.
Otherwise artist names like
The The
The Band
The Duke & the King
The Weeknd
A Fine Frenzy
A Flock of Seagulls
A Guy called Gerald
A Mountain of One
A Tribe called Quest

would look and sound strange.
Where I removed the article, though was for artists who did not really know what their name was: The Rolling Stones or just Rolling Stones, the same with "The Beatles".
In short I would not let such an action run unattended on all my tracks.

3

I see it the same way as @ohrenkino.

I would suggest to only use such a removing Action for a previously filtered part of your collection.
This way you can reduce the risk to remove A or An or The from groups and artists where it really looks "wrong".

It is nearly impossible to guess if the group name "An Dro" should be reduced to "Dro" only. Or if the group "An Emotional Fish" should not be shortened to "Emotional Fish" only.

And don't forget that there are artists only called "An" (Japanese producer, member of AcuticNotes) or AN (Finnish black metal band) or "an" (Japanese visual kei)

4

Same goes for me.

Mostly I am just using it in out of sight column to alphabetize and organize everything.

5

For such a column you don't need an Action, you need the correct Value and/or Sort by.

6

Then it would be an alternative to fill the ~sort field, e.g. ARTST > ARTISTSORT. And in ARTISTSORT you can do with the name what you want so that it fits a good sorting order.
Or you set the property "Sort by" for a column definition.

Did your problem get solved?

7

Yes worked great, You rock!

This I was using to organize some video files placing title info in another column for alphabetizing by first letter. I don't like organizing by a, an or the but like seeing title the way it should be.