Handle_null() using modify stage

[kalpanam]

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.

[sureshbabu]

hi

we can use handle_null(columname,value) in modify stage