Skip to main content
Solved

Search values containing letters ou special caracters

  • June 24, 2022
  • 1 reply
  • 50 views

user01
Contributor
Forum|alt.badge.img+2

Hello,

 

I have one column that is supposed to contain only numbers.

But some values contain letters ou special caracters.

With a Tester Transformer, how can I separate features wich the value contain letters or special caracters ?

 

Thank you

Best answer by nielsgerrits

Multiple ways to do this. One way is to use a Tester transformer. Test if Type Is Numeric.

2022-06-24_16h19_42Alternatives are AttributeValidator, TestFilter, StringSearcher.

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.

1 reply

nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2938 replies
  • Best Answer
  • June 24, 2022

Multiple ways to do this. One way is to use a Tester transformer. Test if Type Is Numeric.

2022-06-24_16h19_42Alternatives are AttributeValidator, TestFilter, StringSearcher.