setting for thousands divider in csv import (and maybe other imports, have only tried csv so far) #16632
Closed
IngoHohmann
started this conversation in
Ideas
setting for thousands divider in csv import (and maybe other imports, have only tried csv so far)
#16632
Replies: 2 comments 1 reply
-
|
Opening new discussions instead of searching for and upvoting existing ones weakens your request power. It also makes you miss temporary workarounds, such as using the |
Beta Was this translation helpful? Give feedback.
1 reply
-
|
Think you, I did a search, but didn't find these, sorry for that. |
Beta Was this translation helpful? Give feedback.
-
|
Duplicate of #15678 |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
In Germany decimal and thousands divider are swapped when compared to the US standard, eg.
1,000.5 would be written as 1.000,5 in Germany.
Now I've got a csv file which basically looks like this:
"Text";"Amount"
"Got some money";"1.000,50"
"Spent some money";"-1.000,50"
And as far as I can see there is no way to import the Amount column as a number format in duckdb.
If it were possible to also set the the tousands divider the scanner should be able to scan these numbers (I hope).
I don't know if this applies to other import formats, too.
Beta Was this translation helpful? Give feedback.
All reactions