TCC field length complex filter
Summary
TCC complex filter to exclude data where the length of a field is less than 9 digitsContent
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