Skip to main content
Question

Test for ISNUMBER() (Is Number)

  • February 7, 2018
  • 3 replies
  • 538 views

dbklingdom
Contributor
Forum|alt.badge.img+7

Is here a transformer or setup a Tester to test an attribute to be a number?

i.e. ISNUMBER() like in SQL

Thx Brian

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

lottegis
Forum|alt.badge.img+1
  • 31 replies
  • February 7, 2018

I would use Regex in a Tester, with this expression:

^\d*$

erik_jan
Contributor
Forum|alt.badge.img+22
  • Contributor
  • 2179 replies
  • February 7, 2018

The AttributeValidator transformer can test for numeric values.


dbklingdom
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • 33 replies
  • February 7, 2018

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