Skip to Content
avatar image
Former Member

Checking the value of field in falt file

hi,

I had query that...

how to check whether the field coming from flat file always contains a value or not..

thanking u

guna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 15, 2008 at 06:37 AM

    Hi,

    U can check with two options.

    Using grahical mapping std functions:

    1) Input value and Constant value with space give it to Equals function which will either give true or false based on true or false u can come to know whether value is present or not.

    2) using UDF.

    pass the input to UDF and write a small java code.

    if(a[0].equals(""));

    {

    result is false

    }

    else

    {

    result is true

    }

    chirag

    Add comment
    10|10000 characters needed characters exceeded