I have one column with this values.
I would like to filter only words that contais ABC letters.
But can´t be JACABC or RDABC. Sometimes the ABC is stay in second or third word after the comma, like image below:
Thank´s
Page 1 / 1
Use StringReplacer to replace space with nothing AttributeSplitter to split by comma (,), then Tester with Begins with ABC.
I think you need a ListExploder someware.
A string searcher with the following Regex should pass any features where ABC is the start of a string of characters at any point in the string, i.e. will match ABC123 but not JACABC123
\bABC\w+\b is the word boundary
ABC are the characters ABC
\w+ is any number of word characters following (letter, number, underscore)
If you then need the actual matches themselves they are stored in the allmatches list which you can then explode, e.g. the last line in your example would match and return ABC6003 & ABC4
A string searcher with the following Regex should pass any features where ABC is the start of a string of characters at any point in the string, i.e. will match ABC123 but not JACABC123
\bABC\w+\b is the word boundary
ABC are the characters ABC
\w+ is any number of word characters following (letter, number, underscore)
If you then need the actual matches themselves they are stored in the allmatches list which you can then explode, e.g. the last line in your example would match and return ABC6003 & ABC4
Thank you very much!