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

Downloading CA's numbers, cant seperate the number from the date.

Topic closed. 8 replies. Last post 8 years ago by Prov1x.

Page 1 of 1
PrintE-mailLink
thudpucker's avatar - animal bear.jpg
New Member
Bethel AL
United States
Member #73324
April 11, 2009
24 Posts
Offline
Posted: April 11, 2009, 9:35 pm - IP Logged

I down loaded CA's Past winning numbers for one of the Ball drawings.

It came in a large file with the Drawing number, date then the two digit numbers and the Ball.

When I tried to put that into Excel it all went into one cell.

If I tried to delete any part of any line, the whole line was deleted.

 

How do you folks get the past winning numbers into Excel?


    United States
    Member #62164
    June 19, 2008
    1217 Posts
    Offline
    Posted: April 11, 2009, 9:45 pm - IP Logged

    I down loaded CA's Past winning numbers for one of the Ball drawings.

    It came in a large file with the Drawing number, date then the two digit numbers and the Ball.

    When I tried to put that into Excel it all went into one cell.

    If I tried to delete any part of any line, the whole line was deleted.

     

    How do you folks get the past winning numbers into Excel?

    Stay tuned, I'll make you something real fast.

      thudpucker's avatar - animal bear.jpg
      New Member
      Bethel AL
      United States
      Member #73324
      April 11, 2009
      24 Posts
      Offline
      Posted: April 11, 2009, 10:06 pm - IP Logged

      WOW! I'm in some deep stuff here.

      Not knowing quite what I was doing, I pasted your link and it downloded something with (I think) instructions to put the "What I downloaded" into the left column, and "what I wanted" into the right column.

      Did I get that right?

      I was trying to get the 5 number columns with a Ball games (Two of them)


        United States
        Member #62164
        June 19, 2008
        1217 Posts
        Offline
        Posted: April 11, 2009, 10:09 pm - IP Logged

        WOW! I'm in some deep stuff here.

        Not knowing quite what I was doing, I pasted your link and it downloded something with (I think) instructions to put the "What I downloaded" into the left column, and "what I wanted" into the right column.

        Did I get that right?

        I was trying to get the 5 number columns with a Ball games (Two of them)

        You load the txt file by clicking Load List and then you open the txt file with notepad and count all the stuff in front of what you actually want including spaces dashes numbers letters everything and place that in the first textbox.  Second you count how long the stuff you want is and put that in the second textbox and click the button.

          thudpucker's avatar - animal bear.jpg
          New Member
          Bethel AL
          United States
          Member #73324
          April 11, 2009
          24 Posts
          Offline
          Posted: April 11, 2009, 10:13 pm - IP Logged

          OK, (tongue in cheek here) I'll copy that down and give it a try. I wont be back till a lot later this evening though.

          Thanks for the explanation.

            time*treat's avatar - radar

            United States
            Member #13130
            March 30, 2005
            2171 Posts
            Offline
            Posted: April 11, 2009, 11:53 pm - IP Logged

            I down loaded CA's Past winning numbers for one of the Ball drawings.

            It came in a large file with the Drawing number, date then the two digit numbers and the Ball.

            When I tried to put that into Excel it all went into one cell.

            If I tried to delete any part of any line, the whole line was deleted.

             

            How do you folks get the past winning numbers into Excel?

            Which game?

            In neo-conned Amerika, bank robs you.
            Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

              thudpucker's avatar - animal bear.jpg
              New Member
              Bethel AL
              United States
              Member #73324
              April 11, 2009
              24 Posts
              Offline
              Posted: April 12, 2009, 2:43 am - IP Logged

              It was the Megamillions. I went to the "Past winning numbers" link and downloded the file.

              It came to me like this;


              395     04-03-2009           16           22           38           39           48           42                             

               

              I just couldnt do anything with it.

                time*treat's avatar - radar

                United States
                Member #13130
                March 30, 2005
                2171 Posts
                Offline
                Posted: April 12, 2009, 4:21 am - IP Logged

                save file (notepad) MegaMillions.txt
                Open Excel

                (In Excel)
                File --> Open (select "Text Files")
                Double-click MegaMillions
                Text Import Wizard (Step 1 of 3) --> check "Delimited" --> Next
                Text Import Wizard (Step 2 of 3) --> check "Space" --> Next
                Text Import Wizard (Step 3 of 3) --> Column data format (General) --> Finish

                (then manually fix the column headers & "autofit" the column widths)

                (then save your new file as an excel spreadsheet)

                In neo-conned Amerika, bank robs you.
                Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.


                  United States
                  Member #62164
                  June 19, 2008
                  1217 Posts
                  Offline
                  Posted: April 12, 2009, 6:37 am - IP Logged

                  It was the Megamillions. I went to the "Past winning numbers" link and downloded the file.

                  It came to me like this;


                  395     04-03-2009           16           22           38           39           48           42                             

                   

                  I just couldnt do anything with it.

                  How could you not understand what I said?  All you do is count the number of characters you want and dont want.

                  29 and 67 for what you just posted.

                  395     04-03-2009           16           22           38           39           48           42