Import Winning Numbers Wizard

Menu: Winning Numbers Import Wizard

In this step you can see the imported data displayed in a table. Each row contains one line of text. The lines are then split into columns using field separator characters. You can enter different separators in the edit field in the upper part of this window. Then click the Apply button to update the table of imported data.

Example: Let's assume you wish to import the following text:

Winning Numbers for year 2004
12/03/2004 1,2,3,4,5,6-7
13/03/2004 11,12,13,14,15,16-17
14/03/2004 21,22,23,24,25,26-27

If you enter fields separators " ," ("space" and "comma"), the lines will be split like this:

Winning Numbers for year 2004    
12/03/2004 1 2 3 4 5 6-7
13/03/2004 11 12 13 14 15 16-17
14/03/2004 21 22 23 24 25 26-27

You can see that these separators are not enough because the draw date and bonus number are not split into individual fields. Enter new field separators " ,/-" ("space", "comma", "slash" "dash") and click the Apply button. The table will look like this:

Winning Numbers for year 2004          
12 03 2004 1 2 3 4 5 6 7
13 03 2004 11 12 13 14 15 16 17
14 03 2004 21 22 23 24 25 26 27

The wizard is now ready to import all winning numbers and draw dates. The wizard will ignore table's first row.

Hint: Double-click any cell to edit its content.

 

Use the Next button to continue with wizard's next step, you can return to wizard's previous step by using the Previous button.