tFilterRow regex not working?

[Remco1]

I'm using the advanced setting in tFilterRow (Open Studio 6.3). I've tried the following code (regex) to filter rows:

java.util.regex.Pattern.compile("\\d+").matcher(input_row.code).find()

java.util.regex.Pattern.compile("\\d*").matcher(input_row.code).find()

java.util.regex.Pattern.compile("[0-9]+").matcher(input_row.code).find()

java.util.regex.Pattern.compile("[0-9]*").matcher(input_row.code).find()

This should return only records where the value of "code" only exists out of digits (0-9), however it does return records with at least one digit and characters. Which regex should I use to return only digit values?

[Anonymous]

Hi,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

[Remco1]

Hello Sabrina,



Thnx for your reply, here's my case. It should only return rows that exists only out of digits (in schema this is column "code" that refers to column K "AUTHORISATIE" in the csv file). It now returns 303 out of 305 records because the value contains a digit, it should return only 40 records (eg in the csv file row K7 which has a value of 113577)



[cid:image002.png@01D34981.D6D5C8E0]



[cid:image004.jpg@01D34982.BA72D3E0]



[cid:image007.jpg@01D34982.BA72D3E0]



With regards,



Remco

[Anonymous]

Hello,

Actually, we cannot see your image from our side. Could you please check it?

Could you please  upload your Screenshots by click 'photos' icon on forum? Feel free to let us know if there is any problem for you.

Best regards

Sabrina

[Remco1]

Hello Sabrina,

Here are the screenshots

Remco

[Anonymous]

Can you try any of below expressions?
java.util.regex.Pattern.compile("^[0-9]+").matcher(input_row.code).find()

Or
java.util.regex.Pattern.compile("^\\d+").matcher(input_row.code).find()

[Remco1]

This doesn't work, it returns 0 records.



Thnx Remco

[Anonymous]

Sorry use matches() method instead of find()

java.util.regex.Pattern.compile("[0-9]+").matcher(input_row.code).matches()

Or
java.util.regex.Pattern.compile("\\d+").matcher(input_row.code).matches()

[Remco1]

Also 0 records...



Remco

[Anonymous · Accepted solution]

One last try for me
input_row.code.trim().matches("[0-9]+")