You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » regex in tmap for string to double check
Post a reply
Topic review (newest first)
- djugal
- 2012-04-24 08:41:18
sorry it was typo error in tmap filter
thx for the help
- 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: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: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: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
- djugal
- 2012-04-23 14:56:46
found it too:
row1.num.matches("-?\\d+(.\\d+)?")
- 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 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