Skip to Content
avatar image
Former Member

Data Services 4.2 : Editor format file

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 !

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 15, 2017 at 01:34 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded