|
|
|
|
Acceptable Delimited Data Formats
| Your Format Input |
Actual Data Processed |
1. New lines:
1.00
2.1
3
4
5
6
7
8
1
0
|
1 2.1 3 4 5 6 7 8 1 0 |
2. Spaces:
1 2.1 3 4 5 6 7 8 1 0
|
1 2.1 3 4 5 6 7 8 1 0 |
3. New line and coma separated:
1,
2,
3,
4,
5,
6,
7,
8,
1,
0,
|
1 2 3 4 5 6 7 8 1 0 |
4. Coma and space separated:
1, 2, 3, 4, 5, 6, 7, 8, 1, 0
|
1 2 3 4 5 6 7 8 1 0 |
5. Coma separated:
1,2,3,4,5,6,7,8,1,0
|
1 2 3 4 5 6 7 8 1 0 |
6. Text can appear after values:
1 love necklace
2 love bracelet
3 rings
4 silver bars
5 necklace
6 diamonds
7 bracelet
8 rings
1 ring
0 other treasures
|
1 2 3 4 5 6 7 8 1 0 |
6. CSV format, where data is separated by double quotes and semicolons:
"1";"2";"3";"4";
"5";"6";"7";"8";
|
1 2 3 4 5 6 7 8 |
|
| Your Format Input |
Actual Data Processed |
7. There is no spaces between words:
1ring
2rings
3rings
4bracelet
5necklace
6glasses
7glasses
8glasses
1goldglasses
0othertreasures
|
1 2 3 4 5 6 7 8 1 0 |
8. Spaces between text and numbers and new lines:
ring 1
rings 2
bracelets 3
bracelets 4
lovebracelets 5
lovebracelets 6
love bracelets 7
love bracelets 8
gold rings 1
silver rings 0
|
1 2 3 4 5 6 7 8 1 0 |
9. Spaces between text and numbers:
gold bar 1 gold rings 2 gold rings 3 silver rings 4 platinum rings 5
diamonds 6 sapphires 7 ruby 8 paltinum rings 1 other rings 0
|
1 2 3 4 5 6 7 8 1 0 |
10. Mixed:
1.1 gold ring 2 gold rings
3 gold rings, 4 silver rings;
5 necklace,
6 necklace.
7 saphire,
8 ruby,
1 gold necklace 0 other
|
1.1 2 3 4 5 6 7 8 1 0 |
11. Ignored values. Digits are at the end or inside in the words:
ring1
bracelet2no
Ring1andRings2
Ring100Ring100
'1';'2';
'3'
|
|
12. Mixed values with digits:
100ring100ring
200ring200ring |
100 200 |
|
|
