Cdg James
 |
 GET BOTH DISCs Male Female Standards Etta James Bobby Darin Karaoke CDG CD Set $9.99 Time Remaining: 29d 12h 46m Buy It Now for only: $9.99 |
 Anne Murray Carole King At Last Etta James Karaoke CDG CD Songs $0.99 Time Remaining: 3d 13h 27m |
 SOUND CHOICE KARAOKE CD+G 8871 James Taylor $17.57 Time Remaining: 23d 14h 53m Buy It Now for only: $17.57 |
 Etta James At Last Bette Midler Female Standards Karaoke CDG CD Disc Songs $9.99 Time Remaining: 27d 10h 21m Buy It Now for only: $9.99 |
 4 DISC Etta James Lou Rawls Percy Sledge RB Soul Motown Karaoke CDG CD Set $14.99 Time Remaining: 24d 9h 36m Buy It Now for only: $14.99 |
 James Taylor Karaoke Collection CD+G 19 TOP Requested Songs $12.59 Time Remaining: 13d 13h 27m Buy It Now for only: $12.59 |
 CHARTBUSTER KARAOKE cdg90090 Sonny James $11.99 Time Remaining: 20d 7h 40m Buy It Now for only: $11.99 |
 POCKET SONGS 1072 KARAOKE CDG James Taylor Hits $13.99 Time Remaining: 11d 15h 29m Buy It Now for only: $13.99 |
 19 Greatest Hits Of James Taylor Karaoke Anthology CDG $13.99 Time Remaining: 29d 23h 10m Buy It Now for only: $13.99 |
 Radio Starz RSZ620 CDG James Taylor Karaoke Anthology $11.95 Time Remaining: 14d 10h 34m Buy It Now for only: $11.95 |
 40 Best Of James Taylor Simon Garfunkel Karaoke CD+G HOT DEAL 2012 $29.99 Time Remaining: 8d 7h 29m Buy It Now for only: $29.99 |
 4 DISC Etta James Percy Sledge Ray Charles RB Soul Motown Karaoke CDG CD Set $9.99 Time Remaining: 5d 7h 44m Buy It Now for only: $9.99 |
 SOUND CHOICE KARAOKE CDG 8871 James Taylor $17.95 Time Remaining: 14d 14h 3m Buy It Now for only: $17.95 |
 James Bond Songs ZOOM Karaoke 26 GOLDFINGER CD+G $14.94 Time Remaining: 18d 13h 13m Buy It Now for only: $14.94 |
 Sound Choice Star SC2218 CDG James Taylor Vol1 $15.95 Time Remaining: 19d 9h 26m Buy It Now for only: $15.95 |
 James Taylor 19 Collection Songs HOTTEST Karaoke cdg620 $11.95 Time Remaining: 13d 11h 13m Buy It Now for only: $11.95 |
 Party Rock Karaoke CDG DEVO B52s BILLY IDOL Rick James RIGHT SAID FRED SamDave $0.99 Time Remaining: 3d 16h 32m |
 Sound Choice CD+G 8871 Hits Of James Taylor Vol 1 $17.95 Time Remaining: 29d 12h 6m Buy It Now for only: $17.95 |
 PHIL COLLINS JAMES INGRAM Karaoke SKG 923 CD+G NEW $6.99 Time Remaining: 13d 14h 33m Buy It Now for only: $6.99 |
 Kind Of A Drag Buckinghams Tommy James Rock Karaoke CDG CD Songs $6.99 Time Remaining: 26d 4h 58m Buy It Now for only: $6.99 |
 At Last Etta James Carole King Garland Female Standards Karaoke CDG CD Songs $3.99 Time Remaining: 5d 5h 54m Buy It Now for only: $3.99 |
 James Taylor Hits POCKET SONGS 1072 KARAOKE CDG $20.00 Time Remaining: 16d 4h 12m Buy It Now for only: $20.00 |
 Just Once James Ingram Annie Lennox Top Hits Karaoke CDG CD Songs $7.99 Time Remaining: 14d 8h 58m Buy It Now for only: $7.99 |
 Phil Collins James Ingram Superstar 923 One More Night One Hundred Ways CD+G $3.99 Time Remaining: 28d 17h 48m Buy It Now for only: $3.99 |
 Sound Choice Karaoke SC8871 CDG James Taylor $16.88 Time Remaining: 1d 20h 1m Buy It Now for only: $16.88 |
 36 Best Of Neil Diamond James Taylor Karaoke CD+G HOT DEAL 2012 $29.99 Time Remaining: 27d 1h 50m Buy It Now for only: $29.99 |
 James Blunt SunFly World Stars Karaoke CDG 095 $18.88 Time Remaining: 14h 3m Buy It Now for only: $18.88 |
 POCKET SONGS 1072 KARAOKE CDG James Taylor Hits $19.99 Time Remaining: 18d 12h 29m Buy It Now for only: $19.99 |
 Make Us An Offer Neil Diamond James Taylor Karaoke 2 CD+G Set 36 Top Hits $26.99 Time Remaining: 28d 7h 29m Buy It Now for only: $26.99 |
 ZOOM KARAOKE CDG ZPA26 Best Of James Bond Movies Hits $18.85 Time Remaining: 13h 46m Buy It Now for only: $18.85 |
 POCKET SONGS 1263 KARAOKE CDG James Bond Themes $26.95 Time Remaining: 18d 12h 36m Buy It Now for only: $26.95 |
 Sonny James Greatest Hits CHARTBUSTER KARAOKE CDG $13.99 Time Remaining: 16d 13h 29m Buy It Now for only: $13.99 |
 Party Rock Karaoke CDG DEVO B52s BILLY IDOL Rick James RIGHT SAID FRED SamDave $0.99 Time Remaining: 4d 15h 59m |
 Neil Diamond James Taylor Karaoke Collection Karaoke 36 songs 2 CD+G Set $26.99 Time Remaining: 27d 1h 50m Buy It Now for only: $26.99 |
 ZOOM KARAOKE CDG ZPA26 James Bond Movies Hits $18.85 Time Remaining: 18d 14h 12m Buy It Now for only: $18.85 |
 James Taylor Simon Garfunkel Karaoke Collection Karaoke 40 songs 2 CD+G Set $24.29 Time Remaining: 6d 14h 12m Buy It Now for only: $24.29 |
 19 Best Of James Taylor Karaoke CD+G Radio Starz Hits HOT DEAL 2012 $15.99 Time Remaining: 4d 13h 19m Buy It Now for only: $15.99 |
 ZOOM KARAOKE CDG ZPA116 James Morrison $18.85 Time Remaining: 18d 14h 11m Buy It Now for only: $18.85 |
 James Taylor GREATEST HITS KARAOKE CDG BEST SELLERS $11.99 Time Remaining: 5d 9h 2m Buy It Now for only: $11.99 |
 SunFly WorldStars Karaoke CDG 095 James Blunt Greatest Hits $12.99 Time Remaining: 6d 12h 38m Buy It Now for only: $12.99 |
 CHARTBUSTER KARAOKE cdg90373 James Brown $11.99 Time Remaining: 12d 15h 11m Buy It Now for only: $11.99 |
 James Brown Greatest Hits CHARTBUSTER KARAOKE CDG $13.99 Time Remaining: 25d 14h 38m Buy It Now for only: $13.99 |
 JAMES INGRAM Karaoke SKG 923 CD+G 13 HITS SuperStar $6.99 Time Remaining: 13d 14h 33m Buy It Now for only: $6.99 |
 POCKET SONGS 1263 KARAOKE CDG James Bond Themes $21.95 Time Remaining: 11d 15h 37m Buy It Now for only: $21.95 |
 Pocket Songs Karaoke CDG 1618 Sing Etta James Hits $22.95 Time Remaining: 22d 5h 31m Buy It Now for only: $22.95 |
 Chartbuster POP6 CDG CB40131 James Brown $15.99 Time Remaining: 28d 4h 32m Buy It Now for only: $15.99 |
 Pocket Songs Karaoke CDG PSCDG1072 Hits Of James Taylor $22.95 Time Remaining: 22d 5h 37m Buy It Now for only: $22.95 |
Remove path string and replace string using a batch file?
I have a text file that lists hundreds of filenames from various subfolders.
Example string from mylist.txt
H:STILL RENAMINGDONE(J's) The Sunfly Karaoke Collection Cdg (11 Of 26)If Loving You Is Wrong - James Ingram & Luther Vandross - Sunfly J.cdg
H:STILL RENAMINGDONECYoung Hearts Run Free - Candi Staton - C.cdg
The batch file should be able to:
1.) remove the pathname
2.) " - " replaced with a tab keystroke like this ""
3.) ".cdg" replaced like this "cdg" ( note that it also has a tab keystroke )
Once finished, it should look like these:
If Loving You Is WrongJames Ingram & Luther VandrossSunfly Jcdg
Young Hearts Run FreeCandi StatonCcdg
The purpose of this is that once mylist.txt is proccessed by the batch file, I can copy and paste the text into Excel. The tab keystroke will be excel's "hint" to divide the text into cells. Is this even possible with a batch file? Alternate solutions welcome too 
Thanks in advance!
First you have to import your txt file into excel then use this add-in StrRight.xla which can be download at http://www.freewebs.com/swhtam/YA/StrRight.xla
After download the xla file above, Go to menu tools, add-ins, browse and locate StrRight.xla, click ok button
GENERAL FORMAT: STRRIGHT( value As String, delimiter As String, occurence As Integer)
USAGE:
say in A1 you got, http://yahoo.com/question/abc/123
= STRRIGHT( A1, "/", 1) then you got 123
= STRRIGHT( A1, "/", 3) then you got question/abc/123
= STRRIGHT( A1, "", 7) then you got abc/123
To make a complete formula that produce the final result
=SUBSTITUTE( SUBSTITUTE( STRRIGHT( A1, "/", 1), " -",""), ".cdg"," cdg")
Hope this helps.
James Person, Chief Operating Officer, CDG, USA at LTE Americas 2009