topic Re: tFilterRow regex not working? in Data Quality

tFilterRow regex not working?

Remco1 — Sat, 16 Nov 2024 09:09:49 GMT

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?

Re: tFilterRow regex not working?

Anonymous — Fri, 20 Oct 2017 07:42:23 GMT

Hi,

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

Best regards

Sabrina

Re: tFilterRow regex not working?

Remco1 — Fri, 20 Oct 2017 08:07:26 GMT

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

Re: tFilterRow regex not working?

Anonymous — Tue, 24 Oct 2017 10:18:06 GMT

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

Re: tFilterRow regex not working?

Remco1 — Tue, 24 Oct 2017 10:30:25 GMT

Hello Sabrina,

Here are the screenshots

Remco

Re: tFilterRow regex not working?

Anonymous — Fri, 03 Nov 2017 18:46:52 GMT

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()

Re: tFilterRow regex not working?

Remco1 — Mon, 06 Nov 2017 08:20:25 GMT

This doesn't work, it returns 0 records.

Thnx Remco

Re: tFilterRow regex not working?

Anonymous — Mon, 06 Nov 2017 13:07:26 GMT

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()

Re: tFilterRow regex not working?

Remco1 — Mon, 06 Nov 2017 13:21:25 GMT

Also 0 records...

Remco

Re: tFilterRow regex not working?

Anonymous — Mon, 06 Nov 2017 13:42:50 GMT

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

Re: tFilterRow regex not working?

Remco1 — Mon, 06 Nov 2017 13:54:25 GMT

That did it for me!!!

Thnx.

Remco