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

4 comments
Comment actions Permalink

@Alex Hippel
This specific feature will be delivered in the nearest releases.

-1
Comment actions Permalink

Still facing this issue 

0
Comment actions Permalink

Alamin Hossain Miraje,

Could you provide a sample CSV file and target table DDL? Also a screenshot of your CSV format settings.

 

0
Comment actions Permalink

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

 

0

Please sign in to leave a comment.