Row filter (different formats)

#1

Hi Knimer,

I have a table with serialno. and I want to filter all no. with a different format.
2019-12-02_15h24_24

E.g. it shall filter all no. if they dont have the format of 111111/2/3333.
In the picture e.g. all rows with “#” and ‘NA’ and 896, or 2122 etc. shall be filtered.

I appreciate your help. Thank you in advance.

Br Alex

0 Likes

#2

Hi @Alex1990

with a Rule Based Row Filter with $Serienummer$ LIKE "/" => TRUE you filter everything with forward slashes.

gr
Hans

4 Likes

#3

HI there @Alex1990,

as @HansS suggested you can use Rule-based Row Filter node with function/operator LIKE. To better define your format you can use wildcards - ? and *. So you can have following expressions depending on what you want to filter:

… LIKE "*/*/*"
… LIKE "??????/?/????"

Also you can use regex if you are familiar with it :wink:

Br,
Ivan

2 Likes

#4

In Addition to Rule-based Row Filter suggested by @HansS and @ipazin, The Row Filter node with this regex pattern does the same job:

\d+/\d+/\d+

You can specify the exact number of digits if it is necessary. E.g:

\d{6}/\d{1}/\d{4}

:blush:

3 Likes

#5

First of all Thank you @armingrudd, @HansS, @ipazin

I tried everything and I prefer the LIKE code with ???/?/??? because it specifies all criteria I need :slight_smile:

@armingrudd the criteria in your screenshot is working well, but the code \d{6}/\d{1}/\d{4} is not working in my case, afterwards it filters all datas

Neverthless, the Rule-based row filter is everything what I want. Thank you :slight_smile:

3 Likes

#6

Sounds great you could find your solution here in forum.

Would you provide a screenshot of your input data?
I tested both patterns on your examples and it worked fine.

:blush:

0 Likes

#7

I tried it again, and it works well, I guess I choose the wrong column to test, in the first time

Thank you :slight_smile:

1 Like