June 16, 2008 at 11:36 pm
Dear friends
My falt file contains a column in the fallowing format:
Date
11/06/08(DD/MM/YY)
12/08/08
00/00/00
13/01/08
00/00/00
If the row appears like 00/00/00 .I'll have to replace with the value "NULL" Instead of 00/00/00
plz guide me.
June 17, 2008 at 12:06 am
Actually very easy, create a derived column with an expression inside
Something like Sourcefieldname == "00/00/00" ? NULL : Sourcefieldname
You will have to read up on the correct Null function to use however...
~PD
June 17, 2008 at 7:22 am
NULLIF(yourcolumn,'00/00/00')
--Jeff Moden
Change is inevitable... Change for the better is not.
June 17, 2008 at 11:15 pm
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply