Handle_null() using modify stage
Posted: Wed Dec 15, 2010 2:12 am
Hi all,
I'm trying to do conversion from string to time.In the input i'm having HOUR_OF_DAY(varchar) nullability as null.first i need to handle null values and then want to convert.
In th input i'm having values as
HOUR_OF_DAY
4:00Am
8:00pm
6:00pm
9:00pm
like wise i'm getting spaces in between.How can I handle these space values.
Please anyone suggest me how to do this?
Thanks,
Kalpana.
I'm trying to do conversion from string to time.In the input i'm having HOUR_OF_DAY(varchar) nullability as null.first i need to handle null values and then want to convert.
In th input i'm having values as
HOUR_OF_DAY
4:00Am
8:00pm
6:00pm
9:00pm
like wise i'm getting spaces in between.How can I handle these space values.
Please anyone suggest me how to do this?
Thanks,
Kalpana.