Welcome Guest
Log In | Register )
You last visited December 5, 2016, 9:28 am
All times shown are
Eastern Time (GMT-5:00)

Jackpot History Parsing Question

Topic closed. 3 replies. Last post 9 years ago by guesser.

Page 1 of 1
PrintE-mailLink
sfilippo's avatar - skull
Oklahoma
United States
Member #33770
February 24, 2006
3146 Posts
Offline
Posted: March 23, 2008, 8:00 pm - IP Logged

Does anyone make copies of LP's jackpot drawing histories like the one below, then paste them into Notepad and manually delete everything but the actual ball numbers so they can be better analyzed?

From this...

Sat, Mar 22, 2008 07-25-28-46-48, Powerball: 19, Power Play: 3
Wed, Mar 19, 2008 06-08-29-41-49, Powerball: 42, Power Play: 4
Sat, Mar 15, 2008 06-22-42-43-47, Powerball: 16, Power Play: 2
Wed, Mar 12, 2008 12-19-30-34-36, Powerball: 08, Power Play: 4
Sat, Mar 8, 2008 17-29-31-34-49, Powerball: 16, Power Play: 2
Wed, Mar 5, 2008 10-15-16-23-31, Powerball: 05, Power Play: 3
Sat, Mar 1, 2008 02-19-21-31-55, Powerball: 19, Power Play: 4
Wed, Feb 27, 2008 20-24-37-48-53, Powerball: 11, Power Play: 5
Sat, Feb 23, 2008 08-13-23-29-47, Powerball: 32, Power Play: 3
Wed, Feb 20, 2008 09-12-20-22-36, Powerball: 31, Power Play: 3
Sat, Feb 16, 2008 03-04-08-20-49, Powerball: 18, Power Play: 3
Wed, Feb 13, 2008 13-19-32-38-51, Powerball: 30, Power Play: 3
Sat, Feb 9, 2008 04-23-24-30-43, Powerball: 28, Power Play: 5
Wed, Feb 6, 2008 03-05-12-42-43, Powerball: 05, Power Play: 5
Sat, Feb 2, 2008 14-16-25-26-44, Powerball: 30, Power Play: 3
Wed, Jan 30, 2008 02-17-41-54-55, Powerball: 17, Power Play: 2
Sat, Jan 26, 2008 11-35-39-53-54, Powerball: 24, Power Play: 2
Wed, Jan 23, 2008 04-16-35-47-48, Powerball: 39, Power Play: 3
Sat, Jan 19, 2008 20-23-25-27-28, Powerball: 02, Power Play: 5
Wed, Jan 16, 2008 09-18-19-38-47, Powerball: 11, Power Play: 5
Sat, Jan 12, 2008 23-39-43-47-53, Powerball: 14, Power Play: 3
Wed, Jan 9, 2008 02-13-20-21-23, Powerball: 24, Power Play: 3
Sat, Jan 5, 2008 04-11-16-33-40, Powerball: 09, Power Play: 4
Wed, Jan 2, 2008 02-11-31-34-48, Powerball: 05, Power Play: 4
Sat, Dec 29, 2007 08-12-17-35-49, Powerball: 18, Power Play: 4
Wed, Dec 26, 2007 08-32-41-54-55, Powerball: 20, Power Play: 3
Sat, Dec 22, 2007 05-10-11-34-38, Powerball: 21, Power Play: 4
Wed, Dec 19, 2007 15-18-22-23-42, Powerball: 37, Power Play: 3
Sat, Dec 15, 2007 22-37-47-48-50, Powerball: 17, Power Play: 3
Wed, Dec 12, 2007 07-14-33-40-55, Powerball: 15, Power Play: 5

To this...

07-25-28-46-48
06-08-29-41-49
06-22-42-43-47
12-19-30-34-36
17-29-31-34-49
10-15-16-23-31
02-19-21-31-55
20-24-37-48-53
08-13-23-29-47
09-12-20-22-36
03-04-08-20-49
13-19-32-38-51
04-23-24-30-43
03-05-12-42-43
14-16-25-26-44
02-17-41-54-55
11-35-39-53-54
04-16-35-47-48
20-23-25-27-28
09-18-19-38-47
23-39-43-47-53
02-13-20-21-23
04-11-16-33-40
02-11-31-34-48
08-12-17-35-49
08-32-41-54-55
05-10-11-34-38
15-18-22-23-42
22-37-47-48-50
07-14-33-40-55

Is anyone doing this or is it just me?

Smiley Steve

    RJOh's avatar - chipmunk
    mid-Ohio
    United States
    Member #9
    March 24, 2001
    19824 Posts
    Offline
    Posted: March 28, 2008, 6:02 pm - IP Logged

    I've done that using Notepad but I use "find and replace" to edit out words like the days,Powerball and Power Play and replace the dash with a common and the month with a number and then save it all as a text file.


    Sat, Mar 22, 2008 07-25-28-46-48, Powerball: 19, Power Play: 3
     
    The above becomes:

    03,22,2008,07,25,28,46,48,19,3

    Then I write a 10 line Basic program that read the above line as a record as follows:

    MO$,DA$,YR$,N1,N2,N3,N4,N5,N7,NT$

    and write that data to a file that my regular program can read.  When I'm looking at a six digit number I also include N6, N7 is always a bonus number and NT$ is a three characters note in my regular program which have the file structure as follow.

    MO$,DA$,YR$,N1,N2,N3,N4,N5,N6,N7,NT$ + line feed

    **Note  NT$ can also be use for jackpot amount

     * you don't need to buy more tickets, just buy a winning ticket * 
       
                 Evil Looking       

      sfilippo's avatar - skull
      Oklahoma
      United States
      Member #33770
      February 24, 2006
      3146 Posts
      Offline
      Posted: March 28, 2008, 6:38 pm - IP Logged

      That's pretty cool, RJOH.

      Looks like you have a method all your own.

      Well, I was just fishing to see if players needed a parser or not. I guess not.

      It comes in handy for me, anyway.

      Thanks for posting!

      Smiley Steve

        guesser's avatar - Lottery-017.jpg

        United States
        Member #41383
        June 16, 2006
        1969 Posts
        Offline
        Posted: March 29, 2008, 1:27 am - IP Logged

        Excel spreadsheet.

        Print on large paper.

        Glue to dartboard.

        Commence throwing....