Importing from CSV - Save empty string as null
Completed
When importing from a CSV file we are able to specify "Null value text".
But often when importing from spreadsheets a blank cell needs to be imported into say a date field.
We therefore need a way of specifying blank as the "Null value text".
I have tried leaving "Null value text" blank and a pair of quote marks but neither worked.
Can you please let me know a way of achieving this or add a feature request so that a blank cell can be treated as a Null.
Thanks
Please sign in to leave a comment.
@Alex Hippel
This specific feature will be delivered in the nearest releases.
Still facing this issue
Alamin Hossain Miraje,
Could you provide a sample CSV file and target table DDL? Also a screenshot of your CSV format settings.
It's been two years so I can't be 100% sure but it looks like the feature was added.
During the import dialogue there is the field "Null value text". This now has the option: Empty string.
There is also the option of "Insert inconvertible values as Null which would also work with a blank for a date column
Alamin Hossain Miraje Perhaps you can confirm it solves your issue.
Thanks