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:
So after filtering this should be the result (all with the same format: 2digits, 4 characters, 6 digits and 1 character
Anyone an idea how to do this?
you can do it with an regex (the row filter node can be configured to check for that)
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
*you can do the regex with inbound abbreviations but I think to see the actual ranges/numbers in the braketa will help for beginners
thanks a lot, this is what I needed
*could you mark this topic as resolved?
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
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.