Move "The" to end of atist up to hyphen

A swapping-ground for Regular Expression syntax

Move "The" to end of atist up to hyphen

Postby zillutl » Wed Mar 28, 2018 7:41 pm

Hello , I would like to move or shift "THE" from the beginning of artist , to the end of artist up to the hyphen with the comma.
Thank You.

example :
format: THE BEATLES-ST.PEPPER to BEATLES,THE-ST.PEPPER
THE EAGLES-HOTEL CALIFORNIA to EAGLES,THE-HOTEL CALIFORNIA

This keeps the artist name in alphabetical order .
zillutl
 
Posts: 2
Joined: Wed Mar 28, 2018 9:00 am

Re: Move "The" to end of atist up to hyphen

Postby KenP » Wed Mar 28, 2018 8:36 pm

Try this.

RegEx (1)
Match: (THE) (.*)(-.*)
Replace: \2,\1\3
KenP
 
Posts: 199
Joined: Sat Jul 30, 2016 11:25 am

Re: Move "The" to end of atist up to hyphen

Postby zillutl » Wed Mar 28, 2018 9:54 pm

Thank You very much .Have a great Day .
zillutl
 
Posts: 2
Joined: Wed Mar 28, 2018 9:00 am


Return to Regular Expressions