Talend community forum / [resolved] filter in tmap

djugal · 2012-05-14 09:05:35

Hi,
I want to apply filter in my job
i/p: string output : string

i/p -------> tmap -------> delete

-------> insert

i want to filter all the text which is numeric or float or null
delete the rest

i tried with
row1.id.matches("-?\\d+(.\\d+)?") in tmap filter
but somehow doesnt wrk for null

i also tried with
Relational.ISNULL(row1.id) &&
row1.id.matches("-?\\d+(.\\d+)?")

but i m getting a nullpointer

can u help

regards,
djugal

pedro · 2012-05-14 09:20:37

Hi Djugal

According to your description, the condition should be like this with "||".

Code:

Relational.ISNULL(row1.id) ||
row1.id.matches("-?\\d+(.\\d+)?")

Besides, the expression of id columns should be as below.

Code:

Relational.ISNULL(row1.id)?"":row1.id

Regards,
Pedro

djugal · 2012-05-14 09:30:15

thks for the quick reply, now the full prob

this is the filterfor the reject records, somehows doesnt wrk
all cols are string output also string

Relational.ISNULL(row16.date)
||
TalendDate.isDate(row16.date,"yyyy-MM-dd HH:mm:ss")==false
||
(row16.c.matches("-?\\d+(.\\d+)?")==false &&
Relational.ISNULL(row16.c))
||
(row16.e.matches("-?\\d+(.\\d+)?")==false &&
Relational.ISNULL(row16.e))
||
(row16.prp.matches("-?\\d+(.\\d+)?")==false &&
Relational.ISNULL(row16.prp))
||
(row16.pr.matches("-?\\d+(.\\d+)?")==false &&
Relational.ISNULL(row16.pr))

Thanks & regards,
djugal

pedro · 2012-05-14 10:06:02

Hi

Please send me an email and attach your job and input data if possible.

Regards,
Pedro

djugal · 2012-05-14 13:18:29

i found the prob:
there is a col which is empty padded with spaces
16 bytes so 16 times space " "
i tried with trim in input but doesnt work, tmap trim func too doesnt help
can u help me

Announcement

Unanswered posts

#1 2012-05-14 09:05:35

[resolved] filter in tmap

#2 2012-05-14 09:20:37

Re: [resolved] filter in tmap

Code:

Code:

#3 2012-05-14 09:30:15

Re: [resolved] filter in tmap

#4 2012-05-14 10:06:02

Re: [resolved] filter in tmap

#5 2012-05-14 13:18:29

Re: [resolved] filter in tmap

Board footer