Skip to Content
0

Data Services 4.2 : Editor format file

Sep 14, 2017 at 08:15 AM

41

avatar image
Former Member

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 !

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dirk Venken
Sep 15, 2017 at 01:34 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded