TCC Complex Filter

Summary

Filtering based on first 3 characters

Content

Hi,

We have stored employee current work location in the UDF, which is like US.New York.HQ. This pattern follows for several countries, for example, Germany would have GR.XXXX.****. Basically the first three characters decide the country of the location and i should extract based on the first 3 characters.

For example: I should extract all the candidate files with work location starting with US.

Help me with a complex filter.

Regards,

Thousif.