Skip to main content
Question

search Nan

  • November 6, 2020
  • 4 replies
  • 29 views

Forum|alt.badge.img

Hi folks,

I have a question from a customer,

how can I locate or find certain "NaN" (Not a number) records inside a Numeric field?

I have tried with : AttributeValidator/option : Attribute is a Numeric,

But I would like to know it there is another better way to do it.

Regards

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.

4 replies

nielsgerrits
VIP
Forum|alt.badge.img+62

I always use a Tester, Type is Numeric. Not sure if one is better, but this feels like the most intuitive solution to me.


Forum|alt.badge.img
  • Author
  • November 6, 2020

ok thanx !


ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • November 6, 2020

ok thanx !

I would use the AttributeValidator if i wanted to check multiple fields at once, a Tester if just one


Forum|alt.badge.img
  • Author
  • November 6, 2020

thanx too !