I'm importing numbers which count quantity of sales. So I can't use the currency data type.
The fact is that numbers more than 999 don't occur too often so I need to balance the time I lose making checks in the txt file (usually I have time because the extraction from the main data system is very slow) with the time I would lose eventually with a more slow elaboration process. I don't know if I could automate the .txt files cleaning that's because I have customers codes with points and numbers too.
I've tried different imports using the wizard.
This is the original file:
Code:
1000;1001;1.000;1.001;1.001,01;1,000;1,001;1,001.01
Import with "," as decimal separator and "." as thousands. All Campo settled to integer long
except for Campo8 and Campo5, settled as double:
ID |
Campo1 |
Campo2 |
Campo3 |
Campo4 |
Campo5 |
Campo6 |
Campo7 |
Campo8 |
1 |
1000 |
1001 |
|
|
1001,01 |
1 |
1 |
1,00101 |
If I settle Campo8 and Campo5 as integer long this is what happens:ID |
Campo1 |
Campo2 |
Campo3 |
Campo4 |
Campo5 |
Campo6 |
Campo7 |
Campo8 |
1 |
1000 |
1001 |
|
|
|
1 |
1 |
1 |
This, if I settle all Campo to double:
ID |
Campo1 |
Campo2 |
Campo3 |
Campo4 |
Campo5 |
Campo6 |
Campo7 |
Campo8 |
1 |
1000 |
1001 |
1000 |
1001 |
1001,01 |
1 |
1,001 |
1,00101 |
For the first try, this is what happen when choosing "." as thousands separator:
ID |
Campo1 |
Campo2 |
Campo3 |
Campo4 |
Campo5 |
Campo6 |
Campo7 |
Campo8 |
1 |
1000 |
1001 |
1 |
1 |
1 |
|
|
|