|
|
|
|
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 gold bar
2 gold bars
3 gold bars
4 silver bars
5 platinum bars
6 diamonds
7 saphire
8 ruby
1 bar of iridium
0 other bars
|
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:
1goldbar
2goldbars
3goldbars
4silverbars
5platinumbars
6diamonds
7saphire
8ruby
1barofiridium
0otherbars
|
1 2 3 4 5 6 7 8 1 0 |
8. Spaces between text and numbers and new lines:
gold bar 1
gold bars 2
gold bars 3
silver bars 4
platinum bars 5
diamonds 6
sapphire 7
ruby 8
bar of iridium 1
other bars 0
|
1 2 3 4 5 6 7 8 1 0 |
9. Spaces between text and numbers:
gold bar 1 gold bars 2 gold bars 3 silver bars 4 platinum bars 5
diamonds 6 sapphire 7 ruby 8 bar of iridium 1 other bars 0
|
1 2 3 4 5 6 7 8 1 0 |
10. Mixed:
1.1 gold bar 2 gold bars
3 gold bars, 4 silver bars
5 platinum bars,
6 diamonds.
7 saphire,
8 ruby,
1 bar of iridium 0 other bars
|
1.1 2 3 4 5 6 7 8 1 0 |
11. Ignored values. Digits are at the end or inside in the words:
bar1
item2no
Thing1andThing2
Item100Item100
'1';'2';
'3'
|
|
12. Mixed values with digits:
100gold100silver
200gold200silver
30paltinum30platimun
1diamond1diamond
|
100 200 30 1 |
|
|
