finding the charecter in the object...

[Former Member]

hi i have one query

suppose i have a data of two field

Name State

tom gujrat

billyard rajasthan

jenyb maharastra

now i want to check in "Name" field ,which are the record contains the letter 'y'

tht means after processing it shoud show output with word 'y' i.e.

Name State

billyard rajasthan

jenyb maharastra

thnks

[Former Member · Accepted solution]

Suppose your Name field comes from TABLEA. Connect TABLEA to a Query transform

Use the following in the Where clause of your Query transform.

match_pattern(TABLEA.Name,'y') = 1

Map the required fields to the Output Schema of the Query transform. The records will be filtered as per your requirement.

Regards,

Suneer

[Former Member · Accepted solution]

grt!!! suneer,..prb solved

thnks a lots

[Former Member · Accepted solution]

hope you'll close the other thread with the same topic.

Regards,

Suneer