Member Avatar for 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

  • 4 Contributors
  • 4 Replies
  • 303 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by jwenting
Member Avatar for JamesCherrill

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

Member Avatar for dippy78

hi,

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

Thanks

Member Avatar for rubberman

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

Member Avatar for 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...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.