Copying data from Data View - replace NULL


Very often I copy the data from the Data View in order to, for example, use it as an input for some data modelling tests but the problem I have is that the NULLs are empty, so the data may look like this:

What I do later on is that I use multi-line editing in VSCode to add '' single quotes, casting, new lines, and aliases. The problem is that empty causes problems.

Is there a way to say that we want the SQL nulls to be replaced with a string NULL when copying data?

1 comment
Yuriy Vinogradov

Yes, you can go here File | Settings | Database | CSV Formats -> Select your format and define 'Null value text' - this field is editable.


Please sign in to leave a comment.