I need help transferring seven years worth of data about NHL (hockey) trades and free agent signings from text that looks like this:
Jan-03
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
etc.
I have seven years worth of text data with approximately 125 transactions per year to code.
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.
Hi
Thanks for providing an opportunity to bid on this project.
We have done such data gathering on the web for clients.
We will be able to complete this task within the deadline.
Also, we will be able to start this task as soon as you approve the bid.
Please let us know if you have any questions on this.
Regards,
Jaikumar
Auroinfotech
India