topic Re: Checking Null values from Delimited File in Talend Studio

Checking Null values from Delimited File

Anonymous — Sat, 30 Jan 2016 12:15:22 GMT

Gurus,
I'm new to talend, just single week old in that.Kindly help me with below scenario.
I have a scenario, where i'm extracting data from Delimited file. I'm using tfilterrow to avoid NULLs.
Used below expression in advanced mode
link.column !=null
Then manually altered the source file with empty string like below
1||3
The above expression doesn't reject that particular record.It's taking all the record to target.

If I use below either expression, it works fine.
!link.column.equals("")
or
!link.column.isEmpty()

Here are my questions.
-->Does delimited file doesn't consider null?
-->Will null be treated as empty string("")?
-->If so, link.column !=null will not work. right?
-->Is it is necessary to include both condition, while checking NULLs or Empty string.
(link.column !=null && !link.column.equals(""))
Thanks

Re: Checking Null values from Delimited File

Anonymous — Sun, 31 Jan 2016 11:25:39 GMT

It is a fact you have to use both methods to check if there is really a value.
I usually use a routine to check this and write this check in a more efficient way.

Re: Checking Null values from Delimited File

Anonymous — Thu, 11 Feb 2016 06:23:56 GMT

jlolling wrote:
It is a fact you have to use both methods to check if there is really a value.
I usually use a routine to check this and write this check in a more efficient way.

Thanks