"Null" Word in csv export

[dippy78]

Hi,

Need help on exporting data to csv from oracle database
when i export ...
the field which has null values (in database) appear as 'null' word in the csv output.
Is there a way to avoid it?

thanks

[JamesCherrill]

What do you want it to do when it encounters a null value in the database?

[dippy78]

hi,

I want it go as blank value ",," and not as ",null," values.

Thanks

[rubberman]

Run it through a sed script to remove the "null" entries.

[jwenting]

NULL is a real value in SQL, hence it gets exported as a real value.
If you want it replaced with something else, adjust the method that writes the output to do the replacement...