Baseball data manipulation - moving imported web text into tables

[fidelityfranchise]

Hi, I am currently trying to import data from a website so that whenever I open up my spreadsheet it automatically updates my data to cut down on some of the time I spend importing each day.

I have an imported web query but the data does not populate into tables like it is in the website it imports as plain text. Right now I have the data drawing from the [import sheet] to a [pitchers sheet] that is easier for me to look at, but there is still a lot of unformated text that I need to get into data tables so I can run my conditional if formulas to manipulate and analyze.

I currently have the data linked from the import sheet to the pitchers sheet as follows:

Imported Data:	Card Toggle 2:20 PM ET MIL @ CHC Weather
Time:	2:20 PM ET
Home:	Chicago Cubs Chicago Cubs
Away:	Milwaukee Brewers Milwaukee Brewers @
Weather:	0%1 PM	0%2 PM	0%3 PM	0%4 PM	ENE ENE wind at 6 mph 48% humidity
Home P:	J. Lester (L) $8.7K
Away P:	W. Peralta (R) $6.6K
Home Team	Home P	Home Throws	Home Salary	Away Team	Away P	Away Throws	Away Salary	Stadium

<tbody>
</tbody>

I need the Home Team to populate from the Home column, as a specific format, Chicago Cubs would be CHC. I believe I can do this with a conditional if? Same thing with the Milwaukee Brewers for the Away Team column, which would be MIL. The problem is that the team names change each day (obviously) and the lengths are not the same.

For Home P, Home Throws, and Home Salary, I need the data to pull from the Home P row and put the players name in the Home P column. I need the Home Thows to draw from the same cell, but pull the (L). Same with the Home Salary, i need the $8.7k from the same cell to read as $8700. This would be repeated for the Away P row and populate the same way in the Away columns. The difficult thing being that the length of characters in the names will change daily and not be consistent.

I have already used a formula in another section of the workbook: =1000*MID(D2,2,LEN(D2)-2) to draw the salary into a number format (where it says $8.7K next to home P), but with the import there is a lot more text in the cells, and the variance is much greater than before of all of the text being salaries.

Does anyone know if what I am trying to do is feasible? I know that I could manually input, but it changes daily and there are around 15 of these each day, so you can imagine that becomes tedious. I appreciate any help/input you guys have. Thanks in advance.