avatar image
Former Member

UDF for replace Null

Hi,

I have to write an UDF

some times source fields are passing this value format like ex: "VALIDTO: 2015-08-19 12:35:24" instead of normal data

If this type of values comes to PI then PI should replace to null value. can you please guide me about to write UDF?

Thank you

Sateesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 25, 2015 at 05:16 AM

    Hi Sateesh,

    From the query it seems you want to replace Date field with Null if input contains VALIDTO string.

    You can achieve this using standard Graphical Mapping node Function.

    startsWith followed by IF Else Check.

    Hope it helps

    Regards,
    Azhar

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content