I need help transferring seven years worth of data about NHL (hockey) trades and free agent signings from text that looks like this:
23- Carolina traded Keith Primeau and a 5th round pick in 2000 to Philadelphia for Rod Brind-Amour, Jean-Marc Pelletier and a 2nd round pick in 2000.
28- Toronto signed Gerald Diduck as a free agent.
I need that text cut and pasted to cells in an Excel document with headings and data something like this:
First name, Last name, team joining, date, trade or free agent
Keith, Primeau, Philadelphia, 01-23-2003, trade
Rod, Brind-Amour, Carolina, 01-23-2003, trade
Jean-Marc, Pelletier, Carolina, 01-23-2003, trade
Gerald, Diduck, Toronto, 01-28-2003, free agent
I have seven years worth of text data with approximately 125 transactions per year to code.
184 freelancers are bidding on average $305 for this job
Hello. Your project looks like fun. I would love to work on it. I am a fast and accurate typist and have experience with breaking text into individual columns. I promise quality work. Give me a chance.