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
Solved
How to filter this words?
+9- Enthusiast
Best answer by ebygomm
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
+23- Contributor
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.
+39- Influencer
- Best Answer
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
+9- Enthusiast
ebygomm wrote:
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!
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.