List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:March 12 1999 4:55pm
Subject:Re: Importing NULL values
View as plain text  
On Thu, Mar 11, 1999 at 07:45:30PM -0500,
garyl.cwa4.epa.gov@stripped wrote:
> and data file:
> 
>      "sally","rogers",,
>      "joe","blo",32,5.5
>      "test","",,

It'd be great if you could put \N where you need a NULL.  You
could try:

sed -e 's/,,/,\\N,/g' -e 's/,$/,\\N/' < datafile > datafile.nulls

Something like that.

Tim
Thread
• Importing NULL valuesgaryl.cwa4.epa.gov12 Mar
  • Re: Importing NULL valuesChris12 Mar
  • Re: Importing NULL valuesThimble Smith12 Mar
  • Re: Importing NULL valuesMicheal Mc Evoy12 Mar
  • Re: Importing NULL valuesChristian Mack12 Mar
  • Importing NULL valuesMichael Widenius15 Mar