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.
LVL 3
Computer GuyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steven HarrisPresidentCommented:
Do you have an example file so we can see the formatting?
0
Computer GuyAuthor Commented:
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
0
Steven HarrisPresidentCommented:
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
0
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

Computer GuyAuthor Commented:
No
0
Steven HarrisPresidentCommented:
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
0
Computer GuyAuthor Commented:
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
0
Steven HarrisPresidentCommented:
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.
0
Rgonzo1971Commented:
Hi,

pls try this formula

=IF(ISNUMBER(1*TRIM(MID(SUBSTITUTE($A1,"-",REPT(" ",200)),1+((COLUMN($B1)-2)*200),200))),TRIM(MID(SUBSTITUTE($A1,"-",REPT(" ",200)),1+((COLUMN(B1)-1)*200),200)),TRIM(MID(SUBSTITUTE($A1,"-",REPT(" ",200)),1+((COLUMN(B1)-2)*200),200)))


see example

Regards
Book6.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.