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