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?
Solved
Testing an integer length?
+6- Contributor
Best answer by david_r
You can use the @StringLength() function, for example if your integer column is called "num":
- Best Answer
You can use the @StringLength() function, for example if your integer column is called "num":
+6- Contributor
david_r wrote:
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!
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.