Hi statalist, I am dealing with precinct by precinct voting results from counties in Texas. My goal is to record elections results (how many votes each person received, who won, etc). While I currently have been just ctrl-f'ing to each precinct and aggregating the results at the end I feel like the data are formatted well enough that if I knew my stata code well enough I could easily transfer this data into a .csv or .dta format.


Here is the example of my code
Code:
0001 001 CALDWELL HTS
                                                      VOTES  PERCENT
           REGISTERED VOTERS - TOTAL .  .  .  .  .  .     0
           BALLOTS CAST - TOTAL.  .  .  .  .  .  .  .   282


          CITY OF ROUND ROCK MAYOR
          VOTE FOR  1
           PATRICK BOSE  .  .  .  .  .  .  .  .  .  .    29    11.15
           SUEANN CAMPBELL  .  .  .  .  .  .  .  .  .    46    17.69
           NYLE MAXWELL  .  .  .  .  .  .  .  .  .  .   185    71.15


          CITY OF ROUND ROCK COUNCIL, PLACE 1
          VOTE FOR  1
           RUFUS HONEYCUTT  .  .  .  .  .  .  .  .  .    84    33.07
           TED WILLIAMSON.  .  .  .  .  .  .  .  .  .    98    38.58
           SHARON IZZO.  .  .  .  .  .  .  .  .  .  .    72    28.35


          CITY OF ROUND ROCK COUNCIL, PLACE 4
          VOTE FOR  1
           CARLOS T. SALINAS.  .  .  .  .  .  .  .  .   189   100.00


          ROUND ROCK ISD TRUSTEE, PLACE 1
          VOTE FOR  1
           YVETTE SANCHEZ.  .  .  .  .  .  .  .  .  .   136    50.18
           KARLA SARTIN  .  .  .  .  .  .  .  .  .  .    43    15.87
           VIVIAN SULLIVAN  .  .  .  .  .  .  .  .  .    92    33.95


          ROUND ROCK ISD TRUSTEE, PLACE 3
          VOTE FOR  1
           PHIL DENNEY.  .  .  .  .  .  .  .  .  .  .    41    15.77
           DIANE COX  .  .  .  .  .  .  .  .  .  .  .   104    40.00
           DEBBIE BRUCE-JUHLKE .  .  .  .  .  .  .  .   115    44.23


          ROUND ROCK ISD TRUSTEE, PLACE 6
          VOTE FOR  1
           DANIEL MCFAULL.  .  .  .  .  .  .  .  .  .    76    28.90
           RAYMOND HARTFIELD.  .  .  .  .  .  .  .  .   108    41.06
           MARK MAUND .  .  .  .  .  .  .  .  .  .  .    79    30.04

PRECINCT REPORT            WILLIAMSON COUNTY, TEXAS
                           JOINT GENERAL ELECTION
                           MAY 7, 2005
RUN DATE:06/01/05 05:02 PM

          0002 002 STONY POINT
                                                      VOTES  PERCENT
           REGISTERED VOTERS - TOTAL .  .  .  .  .  .     0
           BALLOTS CAST - TOTAL.  .  .  .  .  .  .  .   338


          CITY OF ROUND ROCK MAYOR
          VOTE FOR  1
           PATRICK BOSE  .  .  .  .  .  .  .  .  .  .    26     9.52
           SUEANN CAMPBELL  .  .  .  .  .  .  .  .  .    62    22.71
           NYLE MAXWELL  .  .  .  .  .  .  .  .  .  .   185    67.77


          CITY OF ROUND ROCK COUNCIL, PLACE 1
          VOTE FOR  1
           RUFUS HONEYCUTT  .  .  .  .  .  .  .  .  .    96    36.64
           TED WILLIAMSON.  .  .  .  .  .  .  .  .  .   104    39.69
           SHARON IZZO.  .  .  .  .  .  .  .  .  .  .    62    23.66
my end game is to have all the names of candidates and their respective votes. Any advice to hasten my process and dump the manual process of looking at each outcome?