Page 1 of 1
How to find the period "." in a string in transfor
Posted: Tue Mar 04, 2008 4:48 pm
by RAJEEV KATTA
I have a requirement where I need to place a constraint in the transformer which would only send the records to the output Stage where the string contains a period "." .I can do the same using external filter by using grep command but how do I do that in a tranformer I mean which string function can I use to do that.
Posted: Tue Mar 04, 2008 4:53 pm
by chulett
Index.
Posted: Tue Mar 04, 2008 5:35 pm
by ray.wurlod
Code: Select all
Index(InLink.TheString, ".", 1) > 0
Posted: Tue Mar 04, 2008 5:38 pm
by chulett
Posted: Tue Mar 04, 2008 6:30 pm
by Nripendra Chand
one more option:
Dcount(InLink.TheString ,".")<>0
Posted: Tue Mar 04, 2008 9:18 pm
by ray.wurlod
Or just:
There are many ways to skin this particular cat!