asked on

How Can I separate some text with Notepad ++ or Excel?

Hi,

I want songs / artists are in their separated columns.

Also, It's easier for me to do all of the renaming all over again, that's fine too. I still have my original files.

Make: 13 - Gwen Stefani - Crash.mp3 TO "Gwen Stefani", "Crash" (remove "13 - ")
Make: Avicii - Le7els.mp3 TO "Avicii", "Le7els"

I have a few hundred like this.

Steven Harris

Do you have an example file so we can see the formatting?

Computer Guy

ASKER

I have a file with 1 column that has this: Different songs of course.

13 - Gwen Stefani - Crash.mp3
13 - Gwen Stefani - Crash.mp3
Avicii - Le7els.mp3
13 - Gwen Stefani - Crash.mp3
13 - Gwen Stefani - Crash.mp3
13 - Gwen Stefani - Crash.mp3
13 - Gwen Stefani - Crash.mp3
Avicii - Le7els.mp3
13 - Gwen Stefani - Crash.mp3
13 - Gwen Stefani - Crash.mp3
Avicii - Le7els.mp3

Steven Harris

You wouldn't happen to have access to Excel 2013 would you? Flash Fill would take care of this in a few keystrokes:

Excel 2013 - Flash Fill

Computer Guy

ASKER

Steven Harris

What format is the song list in? If it is in a text file, have you tried importing it as a CSV and using the (-) as the separator?

What do you mean by:

Also, It's easier for me to do all of the renaming all over again, that's fine too. I still have my original files.

Can you add additional info to the list for items such as:

Avicii - Le7els.mp3 ---- which has one hyphen; whereas:
13 - Gwen Stefani - Crash.mp3 ---- has two hyphens

Avicii - Le7els.mp3 should be renamed to:

- Avicii - Le7els.mp3

Computer Guy

ASKER

I tried using - as the delimiter and it does not work with the songs that have a "xx - " in front of it.

Nicki Minaj - Starships.mp3
Ray Parker Jr. - Ghostbusters.mp3
13 - LMFAO - Sexy And I Know It.mp3 (basically remove the "13 - " so It's just LMFAO - Sexy And I Know It.mp3)

02 - Jay Sean Lil Wayne - Down.mp3
Cher Lloyd - Want U Back.mp3
"13 - Jay-Z Kanye West, Rihanna

Steven Harris

Unfortunately, it is going to be difficult since there is no standard formatting. You may end up needing a combination of VBA and Manual Editing to get it exactly how you want it, such as:

Format your listing to only show those listings that have two hyphens:

13 - LMFAO - Sexy And I Know It.mp3
02 - Jay Sean Lil Wayne - Down.mp3
13 - Jay-Z Kanye West, Rihanna

and use a formula such as: =REPLACE(A1,1,SEARCH("$$",SUBSTITUTE(A1,"-","$$",1)),"")

If you are not opposed to uploading the file, I would be more than happy to get you started (or complete it) for you.

ASKER CERTIFIED SOLUTION

Rgonzo1971

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial