Read decimal directly from csv
Posted: Mon Jan 25, 2016 3:11 am
Hello,
I am trying to read a decimal column from csv as decimal. The values have a format like this: From -1,23 up to -123.456.789,12
I defined the decimal separator and tried various decimal data type definitions (length, scale) but I don't get the "view data" to run. I get the error:
Field xxx has import error and no default value; data: {- 2 7 1 . 7 8 7 , 9 4}, at offset: 37
Any idea?
Thanks in advance,
Joshi
I am trying to read a decimal column from csv as decimal. The values have a format like this: From -1,23 up to -123.456.789,12
I defined the decimal separator and tried various decimal data type definitions (length, scale) but I don't get the "view data" to run. I get the error:
Field xxx has import error and no default value; data: {- 2 7 1 . 7 8 7 , 9 4}, at offset: 37
Any idea?
Thanks in advance,
Joshi