Icon

kn_​forum_​66998_​regex_​extractor_​capital_​letters

Extract three capital letters from a string with RegEx and compare them to a list

Extract three capital letters from a string with RegEx and compare them to a list

-----------
\s([A-Z]{3})(\s|$)

This RegEx code will find all groups of exactly three uppercase letters in the string that are either preceded and followed by one or more spaces, or are at the end of the string. It will match 'IBM' even though it is at the end of the string without a trailing space.

Extract three capital letters from a string with RegEx and compare them to a listhttps://forum.knime.com/t/internal-comparison-of-two-csv-tables/66998/3?u=mlauber71 \s([A-Z]{3})(\s|$)This RegEx code will find all groups of exactly three uppercase letters in the string that areeither preceded and followed by one or more spaces, or are at the end of the string. It will match'IBM' even though it is at the end of the string without a trailing space. datacurrency_symbol\s([A-Z]{3})(\s|$)https://hub.knime.com/anotherfrauduser/extensions/org.anotherfraud.excel.feature/latest/strip($my_value_regexSubstring$)filtered rows\s([A-Z]{3})(\s|$)Regex Extractorhttps://nodepit.com/node/ws.palladian.nodes.extraction.regex2.RegexExtractor2NodeFactoryhttps://forum.knime.com/t/can-we-extract-the-regex-substring-from-the-string/28467/3?u=mlauber71strip($Full Match$)filtered rows Table Creator Table Creator Regex Substring String Manipulation ReferenceRow Filter Regex Extractor String Manipulation ReferenceRow Filter Extract three capital letters from a string with RegEx and compare them to a listhttps://forum.knime.com/t/internal-comparison-of-two-csv-tables/66998/3?u=mlauber71 \s([A-Z]{3})(\s|$)This RegEx code will find all groups of exactly three uppercase letters in the string that areeither preceded and followed by one or more spaces, or are at the end of the string. It will match'IBM' even though it is at the end of the string without a trailing space. datacurrency_symbol\s([A-Z]{3})(\s|$)https://hub.knime.com/anotherfrauduser/extensions/org.anotherfraud.excel.feature/latest/strip($my_value_regexSubstring$)filtered rows\s([A-Z]{3})(\s|$)Regex Extractorhttps://nodepit.com/node/ws.palladian.nodes.extraction.regex2.RegexExtractor2NodeFactoryhttps://forum.knime.com/t/can-we-extract-the-regex-substring-from-the-string/28467/3?u=mlauber71strip($Full Match$)filtered rows Table Creator Table Creator Regex Substring String Manipulation ReferenceRow Filter Regex Extractor String Manipulation ReferenceRow Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: A9699459
Created at: 2023-05-15
On NodePit since: 2023-05-15
Last update: 2024-04-30
Created with KNIME version: v4.7.2
Tags: regexextract

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!