Is here a transformer or setup a Tester to test an attribute to be a number?
i.e. ISNUMBER() like in SQL
Thx Brian
I would use Regex in a Tester, with this expression:
^\d*$
The AttributeValidator transformer can test for numeric values.
Hey, Head slap Validator!! When I saw ^\\d*$ it reminded me of an Oracle operate I've use in the past which works as well ^-?[[:digit:],.]*$
Many Thanks All
17 votes
16 votes
10 votes
8 votes
6 votes
5 votes
4 votes
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.