using retrosheet to figure total pitches thrown by pitcher

using retrosheet to figure total pitches thrown by pitcher

chiefjamesp 1236430157|%e %b %Y, %H:%M %Z|agohover

Hello! I was wondering if anyone could suggest some simple ways to get a txt file created using bevent into a database…I used bevent to print the pitch sequence and pitcher for each at bat…I was gonna import it into excel and use the len function to count the length of each pitch sequence (which would give me a list of pitcher and number pitches for each at bat) and then load it into my database and use sqlyog to sum pitches by pitcher id…I guess I am wondering if there is a way to just import the txt as a table into sql, and sum the pitches by pitcher id? Hope I explained my question almost clearly…sorry otherwise!

Re: using retrosheet to figure total pitches thrown by pitcher

Colin Wyers 1236527602|%e %b %Y, %H:%M %Z|agohover

Probably more than you bargained for, but I finally wrote out a Retrosheet tutorial.

Re: using retrosheet to figure total pitches thrown by pitcher

chiefjamesp 1236570630|%e %b %Y, %H:%M %Z|agohover

oh man, I was really hoping you might write a tutorial exactly like this at! thank you so much!

Re: using retrosheet to figure total pitches thrown by pitcher

chiefjamesp 1237212330|%e %b %Y, %H:%M %Z|agohover

could anyone help me parse the pitch sequence strings? i'd like to remove all pickoff throws from the strings, and my best effort was gonna be to use the replace function to delete them essentially, but i was wondering if someone knows a way to pull the characters that represent pitches out of the string and into a new column (is that possible?) any ideas, as always, are greatly appreciated, have an awesome day!