Page 1 of 1

Search and Rename many errors from text file.

PostPosted: Sat Dec 02, 2017 8:35 am
by larryisme
Have a folder of karaoke files. Many of the artists have been put in improperly and should be "last name, first name".
I've compiled a text file that has the majority of artist in the first column in the improper form and the second column next in Proper format.

A script that would search through each entry in the master list and replace.

EXAMPLE FROM TEXT FILE NAMED IMPROPER.TXT:
Patti Smith|Smith, Patti
Patti Rothberg|Rothberg, Patti
Patty Loveless|Loveless, Patty
Patty Smyth|Smyth, Patty
Patty Weaver|Weaver, Patty
Paul Anka|Anka, Paul
Paul Baloche|Baloche, Paul
Paul Brandt|Brandt, Paul
Paul Carrack|Carrack, Paul


EXAMPLE PORTION OF SONG FILES IN FOLDER OPEN IN BRU:
Patty Loveless - How Can I Help You Say Goodbye - Cb006-01.cdg
Patty Loveless - How Can I Help You Say Goodbye - Cb006-01.mp3
Patty Loveless - I M That Kind Of Girl - Cb006-01.cdg
Patty Loveless - I M That Kind Of Girl - Cb006-01.mp3
Patty Loveless - Lovin All Night - Cb005-01.cdg
Patty Loveless - Lovin All Night - Cb005-01.mp3
Loveless, Patty & Travis Tritt - Out Of Control Raging Fire - Cb60222-07.cdg
Patty Loveless & Travis Tritt - Out Of Control Raging Fire - Cb60222-07.mp3
Loveless, Patty - Blame It On Your Heart - Cb60011-06.cdg
Loveless, Patty - Blame It On Your Heart - Cb60011-06.mp3
Loveless, Patty - Blame It On Your Heart - Cb90049-01.cdg
Loveless, Patty - Blame It On Your Heart - Cb90049-01.mp3
Loveless, Patty - Blue Memories - Cb60102-02.cdg
Loveless, Patty - Blue Memories - Cb60102-02.mp3
Loveless, Patty - Blue Memories - Cb90048-11.cdg
Loveless, Patty - Blue Memories - Cb90048-11.mp3
Loveless, Patty - Blue Side Of Town, The - Cb60084-04.cdg
Loveless, Patty - Blue Side Of Town, The - Cb60084-04.mp3
Loveless, Patty - Blue Side Of Town, The - Cb90048-03.cdg
Loveless, Patty - Blue Side Of Town, The - Cb90048-03.mp3
Loveless, Patty - Boys Are Back In Town, The - Cb60226-06.cdg
Loveless, Patty - Boys Are Back In Town, The - Cb60226-06.mp3
Loveless, Patty - Boys Are Back In Town, The - Cb80138-02.cdg
Loveless, Patty - Boys Are Back In Town, The - Cb80138-02.mp3
Loveless, Patty - Can't Get Enough - Cb20067-08.cdg
Loveless, Patty - Can't Get Enough - Cb20067-08.mp3
Loveless, Patty - Can't Get Enough - Cb60160-04.cdg
Loveless, Patty - Can't Get Enough - Cb60160-04.mp3
Loveless, Patty - Can't Get Enough - Cb90049-09.cdg
Loveless, Patty - Can't Get Enough - Cb90049-09.mp3
Loveless, Patty - Can't Stop Myself From Loving You - Cb60104-09.cdg
Loveless, Patty - Can't Stop Myself From Loving You - Cb60104-09.mp3
Loveless, Patty - Can't Stop Myself From Loving You - Cb90048-14.cdg
Loveless, Patty - Can't Stop Myself From Loving You - Cb90048-14.mp3