Skip to main content
Solved

TestFilter Parameters

  • July 27, 2018
  • 6 replies
  • 41 views

Forum|alt.badge.img

I am a new user trying to split out TRUE FALSE values contained in column Web with the TestFilter, but can't seem to hit on the correct Test Condition. Each time I Run Translation everything goes through to Unfiltered. It would appear that the TestFilter isn't recognising Alpha characters.

When I change alpha TRUE to numeric 1 then the TestFilter works fine.

 

This doesn't help when I have Alpha Numeric values such as 06HaaR.

I would value assistance in this regard please.

Cheers

Best answer by giarcnomis

As I said, "I am a new user" and am feeling my way and don't understand a lot of the terminology.

After playing around with the parameters with a bit of trial and error, I have stumbled onto the answer.

The operator field needs to be set to Contains Regex.

My issue appears to be resolved. Cheers

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.

6 replies

pratap
Contributor
Forum|alt.badge.img+12
  • Contributor
  • 605 replies
  • July 27, 2018

Hi,

I think, Web column have formula instead of value.

Connect the reader to inspector and see the contents of web column initially. Later pass the respective value instead of "FALSE"

Pratap


Forum|alt.badge.img
  • Author
  • 16 replies
  • July 27, 2018

Hi,

I think, Web column have formula instead of value.

Connect the reader to inspector and see the contents of web column initially. Later pass the respective value instead of "FALSE"

Pratap

All cells contain values and no formulas

 

 


pratap
Contributor
Forum|alt.badge.img+12
  • Contributor
  • 605 replies
  • July 27, 2018

Can you send sample data of the 2018-07-27-14-14-32.png to review and suggest


pratap
Contributor
Forum|alt.badge.img+12
  • Contributor
  • 605 replies
  • July 27, 2018
All cells contain values and no formulas

 

 

Sample data is required to check... this is something strange than expected.

 

 


Forum|alt.badge.img
  • Author
  • 16 replies
  • Best Answer
  • July 27, 2018

As I said, "I am a new user" and am feeling my way and don't understand a lot of the terminology.

After playing around with the parameters with a bit of trial and error, I have stumbled onto the answer.

The operator field needs to be set to Contains Regex.

My issue appears to be resolved. Cheers


ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3430 replies
  • July 27, 2018

As I said, "I am a new user" and am feeling my way and don't understand a lot of the terminology.

After playing around with the parameters with a bit of trial and error, I have stumbled onto the answer.

The operator field needs to be set to Contains Regex.

My issue appears to be resolved. Cheers

It's likely that there are hidden/non printing characters in your column which is why the equals condition isn't working