CSV Export - decimal fields #1134
-
|
Hello, In MariaDB, I have decimal fields like this: 
I need to export them to CSV using the semicolon as the separator. Whenever I export to CSV, the decimal values are enclosed in quotes. I want a result similar to the constant 3. 
Is there a function in Adminer to prevent quotes around my decimal values after exporting to CSV? Regards, |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 1 reply
-
|
This is by purpose. Without the quotes, spreadsheets trim the trailing zeroes. There's no way how to disable this in Adminer but perhaps you can create your own export plugin. You can use e.g. dump-json for inspiration. |
Beta Was this translation helpful? Give feedback.
-
|
Ok, thanks for the explanation. |
Beta Was this translation helpful? Give feedback.
This is by purpose. Without the quotes, spreadsheets trim the trailing zeroes. There's no way how to disable this in Adminer but perhaps you can create your own export plugin. You can use e.g. dump-json for inspiration.