Skip to main content
Solved

TestFilter Parameters


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

View original
Did this help you find an answer to your question?

6 replies

pratap
Contributor
Forum|alt.badge.img+11
  • Contributor
  • 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
  • July 27, 2018
pratap wrote:

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+11
  • Contributor
  • 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+11
  • Contributor
  • July 27, 2018
giarcnomis wrote:
All cells contain values and no formulas

 

 

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

 

 


Forum|alt.badge.img
  • Author
  • 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+39
  • Influencer
  • July 27, 2018
giarcnomis wrote:

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

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings