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.