How to find the period "." in a string in transfor

RAJEEV KATTA · Post by **RAJEEV KATTA** » Tue Mar 04, 2008 4:48 pm

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.

chulett · Post by **chulett** » Tue Mar 04, 2008 4:53 pm

Index.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 04, 2008 5:35 pm

Code: Select all

Index(InLink.TheString, ".", 1) > 0

chulett · Post by **chulett** » Tue Mar 04, 2008 5:38 pm

Or just:

Code: Select all

Index(InLink.TheString, ".", 1)

Nripendra Chand · Post by **Nripendra Chand** » Tue Mar 04, 2008 6:30 pm

one more option:

Dcount(InLink.TheString ,".")<>0

ray.wurlod · Post by **ray.wurlod** » Tue Mar 04, 2008 9:18 pm

Or just:

Code: Select all

Count(InLink.TheString, ".")

There are many ways to skin this particular cat!