+2
Hello, is there a way to test an integer's length within the TestFilter transformer? I have an integer column that can be freely populated with values, but I need to flag rows that are not 6 characters long. Is there some operation in the Test Clauses window that I can use to test for this?
Best answer by david_r
View original
You can use the @StringLength() function, for example if your integer column is called "num":
+26
You can use the following in the TestFilter.
@StringLength(@Value(att)) < 6
+2
You can use the @StringLength() function, for example if your integer column is called "num":
Oh that is it! Thanks so much David. I had found the @StringLength function but wasn't nesting it with the @Value function. Right before you posted this, I was testing using the StringLengthCalculator to create temporary attributes and test them. This solution simplifies things a lot for me, thanks again!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.