Question Re: Data Services 4.2 : Editor format file in Technology Q&A

Data Services 4.2 : Editor format file

Former Member — Thu, 14 Sep 2017 08:15:56 GMT

Hi,

When generating a csv file, how do you convert a NULL value to "" ?
I do not want to change the developments.
I would like to find a solution in the file format editor.
Do you have an idea ?

Thanks for your help !

Re: Data Services 4.2 : Editor format file

former_member187605 — Fri, 15 Sep 2017 13:34:36 GMT

The opposite is possible, i.e. using a certain value as null indicator. Not what you're looking for. You'll need to map your columns using nvl(<col>,'').

You could also specify a default value at database level for the columns in your target table.