Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
TCC field length complex filter — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

TCC field length complex filter

Received Response
15
Views
7
Comments
edited Oct 13, 2020 4:09PM in Taleo Enterprise 7 comments

Summary

TCC complex filter to exclude data where the length of a field is less than 9 digits

Content

Hello - I'm hoping someone can provide some direction on a TCC filter I'm trying to figure out.  I have a complex projection that uses LENGTH and REGEXP_REPLACE customFunctions that strips out non digits and decodes if a candidates SSN is 9 digits or not.  However, I would prefer to filter off these rows entirely and I can't seem to figure out a complex filter that does the same thing.  Has anyone tried to filter based on the length of a field?  Does anyone have any other thoughts on how I can filter out data based on the length of a

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!