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?

0

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

1

请先登录再写评论。