Copying data from Data View - replace NULL
Answered
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?
Please sign in to leave a comment.
Yes, you can go here File | Settings | Database | CSV Formats -> Select your format and define 'Null value text' - this field is editable.