topic Re: How to use tmap filter for below condition in Talend Studio

How to use tmap filter for below condition

_AnonymousUser — Wed, 21 Dec 2016 17:10:31 GMT

I need help in writing the below SQL format into talend tmap filter condition format

isnumeric([size=2][font=Courier New]columnA)=1 and len(columnA) = 12[/font][/size]

Re: How to use tmap filter for below condition

_AnonymousUser — Wed, 21 Dec 2016 17:25:04 GMT

NUM(InsertConsumer.IntegrationCode):1 && LEN(IntegrationCode):12

will this work?

Re: How to use tmap filter for below condition

Anonymous — Thu, 22 Dec 2016 02:45:30 GMT

Hi,
What does your job look like? Elaborating your case with an example with input and expected output values will be preferred.
Best regards
Sabrina