Use Rowfilter with specific format characters, digits

Hi,

I like to use a rowfilter for data in a column. But like to filter on 2 digits, 4 Characters, 4 digits,
The data in the column looks like this:
20VWPG012001A
20VWPG012015A
20PRTF012001A
20VWPG012B01A
20VWPG014B01A
20VWPG012F02A
20VWPG012003A

So after filtering this should be the result (all with the same format: 2digits, 4 characters, 6 digits and 1 character
20VWPG012001A
20VWPG012015A
20PRTF012001A
20VWPG012003A

Anyone an idea how to do this?

Thanks,
Ron

hi @RonG,

you can do it with an regex (the row filter node can be configured to check for that)

[0-9]{2}[a-zA-Z]{4}[0-9]{4}.*
So translates check the string
for 2 repeating numbers between 0-9
followed by characters between a-z repeating 4 times
followed by number between 0-9 repeating 4 times
followed by any character or number (the dot) any amount of times (the star)

if your string should start with that format you can add a ^ to indicate that
^[0-9]{2}[a-zA-Z]{4}[0-9]{4}.*

*you can do the regex with inbound abbreviations but I think to see the actual ranges/numbers in the braketa will help for beginners :slight_smile:

2 Likes

thanks a lot, this is what I needed

1 Like

hi @RonG
great!
*could you mark this topic as resolved?

Hi!

just a note @RonG, when you mark reply as solution quote is added to original post with link to solution so when others with similar issue look at your question they can jump to solution right away. So in this case marking first @AnotherFraudUser reply as solution makes more sense :wink:

Br,
Ivan

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.