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

This project received 5 bids from talented freelancers with an average bid price of $32 USD.

Get free quotes for a project like this
Project Budget
Total Bids
Project Description

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online