TCC Complex Filter
SummaryFiltering based on first 3 characters
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.