Talend community forum / regex in tmap for string to double check

djugal · 2012-04-23 13:38:47

Hi,

i have a string field as as input.
i want to check in tmap is Double with help of regex. how can i do it.
Also string to date in format "yyyy-MM-ddTHH:mm:ss"

Regards,
Jugal

djugal · 2012-04-23 14:24:02

ok so i found for date i can use the function Talend.isDate()
but need help for double check

djugal · 2012-04-23 14:56:46

found it too:
row1.num.matches("-?\\d+(.\\d+)?")

djugal · 2012-04-24 08:11:38

found that function Talend.isDate() doesnt help,
string is input,
date is out put in format "yyyy-MM-dd'T'HH:mm:ss"
how can i apply filter if string is date or not in tmap

pedro · 2012-04-24 08:21:28

Hi Jugal

I think it works fine.
My input string is "2012-04-13T14:17:22".
The expression in tMap is TalendDate.isDate(row1.newColumn,"yyyy-MM-dd'T'HH:mm:ss").
And the result is true.
Or I misunderstand what you mean.

Regards,
Pedro

djugal · 2012-04-24 08:27:58

yeah thts correct,
but i want the rejected records to be deleted,
so wat i did is in the main output i keep the filter TalendDate.isDate(row1.newColumn,"yyyy-MM-dd'T'HH:mm:ss")

for the 2nd out in the tmap i select "Catch output reject"
& tht out frm the tmap is directed to delete rows db2 output

but somehow allows all the rows valid

pedro · 2012-04-24 08:38:52

Hi

'Catch output reject' will work when there is join in tMap.

Why don't you use the filter expression as below in out2?

Code:

TalendDate.isDate(row1.newColumn,"yyyy-MM-dd'T'HH:mm:ss")==false

Regards,
Pedro

djugal · 2012-04-24 08:41:18

sorry it was typo error in tmap filter
thx for the help

Announcement

Unanswered posts

#1 2012-04-23 13:38:47

regex in tmap for string to double check

#2 2012-04-23 14:24:02

Re: regex in tmap for string to double check

#3 2012-04-23 14:56:46

Re: regex in tmap for string to double check

#4 2012-04-24 08:11:38

Re: regex in tmap for string to double check

#5 2012-04-24 08:21:28

Re: regex in tmap for string to double check

#6 2012-04-24 08:27:58

Re: regex in tmap for string to double check

#7 2012-04-24 08:38:52

Re: regex in tmap for string to double check

Code:

#8 2012-04-24 08:41:18

Re: regex in tmap for string to double check

Board footer