Fix a half-done fun music program (only one or two php needs fixing)

Put "Eminem" for example in the box at

[url removed, login to view]

you can see what this program does.

This program searches Youtube API for video titles and then extract information.

I will send you the program once you post a message.

Write something to the message box so that I can send zip.

The program extracts song, artist, featuring artist info from youtube titles.

But as you can see, there are many errors.

I hope you do as much as possible to clean the result.

But at least the following should be done.

1. If the title contains more than one " - ", just don't include that title whatsoever.

Don't even take that into account.

Note that it is OK to contain multiple "-", but not OK to contain multiple " - ".

2. I will make my own artists.xlsx. (You don't have to make it.)

Once I click the start button the program will start with the artist in the first column-first

row of [url removed, login to view],

and it all things are complete, then it will start extracting info about the artist in the first

column-second row of artists.xlsx.


Eminem , Skylar Grey Lyrics (Wrong. the space)

Eminem, Skylar Grey Lyrics (correct)

4. The current version can't get the featuring artist info from the following title.

Fort Minor - Remember the Name (Ft. Eminem and 50 Cent)

Perhaps this is because it contains "Ft" rather than "ft".

5. If (XXX) or [XXX] or {XXX} appear, then please delete the whole (XXX) or [XXX] or {XXX}

EXCEPTION: I said the program should use [url removed, login to view] to know what artist to search for.

Say the rist row of [url removed, login to view] is "Madonna". The program will start with Madonna.

If in XXX there is no artist name, that is, if it is something like (XX Eminem),

then please just delete "(" and ")" and then apply the artist,song,featuring distinguishing


6. You see the program makes many "lines" with song, artist, featuring artist, and original


If the program puts "Rihanna" and "Dr. Dre" in the song column,

then it means it is wrong because "Rihanna" and "Dr. Dre" are artists, not songs.

To fix this, I made artistsfix.xlsx.

In the example [url removed, login to view] that I attached, there are Rihanna and Dr. Dre.

So if any of the line contains Rihanna or Dr. Dre, the line should be deleted.

7. There should be no blank column.

Skills: PHP, Software Architecture, Web Scraping

See more: write api freelance, what is a algorithm, what freelance means, what does freelance, what does algorithm, what algorithm means, web search freelance, web artists, things to do freelance, the second song, second song lyrics, search for artists, search algorithm example, search a freelance, scraping freelance, program c++ freelance, program algorithm example, post my music video, one space freelance, needs of artists, music video with lyrics, music video post, music for freelance, make a video lyrics, make a music video with lyrics

About the Employer:
( 39 reviews ) Seoul, Korea, Republic of

Project ID: #4355339

5 freelancers are bidding on average $32 for this job


Hi, I'm interested. Let me take a look at the program. Thanks.

$35 USD in 3 days
(2 Reviews)

Ready to start.

$30 USD in 3 days
(1 Review)

Dear sir, I am new on but I have 3+ years professional experience on PHP, CodeIgniter(MVC) and Opencart(for E-commerce website). I have read all of requirement of your project and I am honestly said I ca More

$30 USD in 2 days
(0 Reviews)

leader in Core PHP, WordPress,Joomla development, Customizations and testing . It includes WordPress Theme and WordPress Plugins development, Converting existing site to WordPress CMS or creating WordPress based site f More

$30 USD in 1 day
(0 Reviews)

Greetings Dear, I can fix these errors. check PM

$35 USD in 4 days
(0 Reviews)