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

• thudpucker

  

  Bethel AL
  United States
  Member #73,322
  April 11, 2009
  24 Posts
  Offline
  Apr 11, 2009, 9:35 pm

  ▲▼

  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?
• Prov1x

  United States
  Member #62,162
  June 19, 2008
  1,217 Posts
  Offline
  Apr 11, 2009, 9:45 pm

  ▲▼
  In response to thudpucker

  Quote: Originally posted by thudpucker on Apr 11, 2009

  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

  

  Bethel AL
  United States
  Member #73,322
  April 11, 2009
  24 Posts
  Offline
  Apr 11, 2009, 10:06 pm

  ▲▼

  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)
• Prov1x

  United States
  Member #62,162
  June 19, 2008
  1,217 Posts
  Offline
  Apr 11, 2009, 10:09 pm

  ▲▼
  In response to thudpucker

  Quote: Originally posted by thudpucker on Apr 11, 2009

  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

  

  Bethel AL
  United States
  Member #73,322
  April 11, 2009
  24 Posts
  Offline
  Apr 11, 2009, 10:13 pm

  ▲▼

  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

  

  United States
  Member #13,130
  March 30, 2005
  2,171 Posts
  Offline
  Apr 11, 2009, 11:53 pm

  ▲▼
  In response to thudpucker

  Quote: Originally posted by thudpucker on Apr 11, 2009

  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

  

  Bethel AL
  United States
  Member #73,322
  April 11, 2009
  24 Posts
  Offline
  Apr 12, 2009, 2:43 am

  ▲▼

  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

  

  United States
  Member #13,130
  March 30, 2005
  2,171 Posts
  Offline
  Apr 12, 2009, 4:21 am

  ▲▼

  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.
• Prov1x

  United States
  Member #62,162
  June 19, 2008
  1,217 Posts
  Offline
  Apr 12, 2009, 6:37 am

  ▲▼
  In response to thudpucker

  Quote: Originally posted by thudpucker on Apr 12, 2009

  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