Create regular expressions as easy as a breeze. This node allows you to build, preview, and test your regexes in real time with your real data. Say good bye to creating your regex in KNIME with trial and error, or copying back and forth regular expressions and text between your favorite regex tool and KNIME. The user interface is inspired by RegExr and Regular Expressions 101.
The node uses Java’s Pattern
implementation. For each row or text input, it will extract all
matches. Each capturing group is automatically mapped to a KNIME
column. To define the column names, you can make use of
“named capturing groups”, such as
(?<name>[A-Z-a-z]+).
To exclude groups from the output, define them as “non-capturing group”: (?:).
Usage Example: Extract email addresses from text
For this input text: “Hello, world! mail@palladian.ai The
quick brown fox jumps over the lazy dog. bob@example.com Lorem
ipsum.” and the
\b(?<Local Part>[A-Z0-9._%+-]+)@(?<Domain>[A-Z0-9.-]+\.[A-Z]{2,})\b,
the node will create a KNIME table as follows:
| Full Match | Local Part | Domain |
|---|---|---|
| mail@palladian.ai | palladian.ai | |
| bob@example.com | bob | example.com |
Standalone Mode
The node can be used with an input table, which provides a string column, or in “standalone” mode (when no input table is connected), where you can enter the text into the node dialog.
Further reading
For a general introduction into regular expressions, have a look at Regular-Expressions.info.
Options
Popular Predecessors
Regex Extractor5 %- Joiner4 %
- Tika Parser3 %
- Document Data Extractor3 %
- Chunk Loop Start2 %
- Constant Value Column2 %
- Webpage Retriever2 %
Row Filter (deprecated)1 %Loop End1 %- Column Expressions1 %
- String Manipulation (Multi Column)1 %
- Column Appender1 %
- Reference Row Splitter1 %
- Group Loop Start1 %
- Column Combiner1 %
- HTML Parser1 %
- Index Query1 %
- Concatenate1 %
- File Reader (Complex Format)1 %
- Row Filter (Labs)1 %
- String Manipulation< 1 %
- JSON Path< 1 %
- PDF Parser< 1 %
- Path to String< 1 %
- Variable to Table Row< 1 %
- Java Snippet< 1 %
- Tika Parser URL Input< 1 %
List Files< 1 %- Number to String< 1 %
Column Rename< 1 %- Math Formula< 1 %
- Missing Value Column Filter< 1 %
- Table Column to Variable< 1 %
- HiLite Row Splitter< 1 %
- Sorter< 1 %
- String Manipulation (Variable)< 1 %
- Missing Value< 1 %
- Cross Joiner< 1 %
- Extract Text< 1 %
- Table View (JavaScript)< 1 %
- mbox Message Part Extractor< 1 %
- Column Aggregator< 1 %
- Duplicate Row Filter< 1 %
Joiner< 1 %- DB Reader< 1 %
- Bag Of Words Creator< 1 %
- Strings to Document< 1 %
- Web Page Content Extractor< 1 %
- Try (Data Ports)< 1 %
- Table Row to Variable< 1 %
- CSV Reader< 1 %
- File Reader< 1 %
- String to XML< 1 %
- URL Extractor< 1 %
- URL to File Path< 1 %
File Reader< 1 %- Nominal Value Row Filter< 1 %
- Reference Row Filter< 1 %
- GroupBy< 1 %
- Table Transposer< 1 %
- Rule Engine< 1 %
- DB Query Reader< 1 %
- RegEx Filter< 1 %
- Python Source (legacy)< 1 %
- Date&Time-based Row Filter< 1 %
- Load Text Files< 1 %
- Get WebElement Data< 1 %
- Create Collection Column< 1 %
- Loop End< 1 %
- Column Rename (Regex)< 1 %
- Table Validator< 1 %
- Table Manipulator< 1 %
- RowID< 1 %
- Row Sampling< 1 %
- Variable Expressions< 1 %
- List Files/Folders< 1 %
- Modify Time< 1 %
- Wait< 1 %
- CSV Writer< 1 %
- URL Decode< 1 %
- Table Creator< 1 %
- Column List Loop Start< 1 %
- Cell Splitter< 1 %
- String to Number< 1 %
- Column Merger< 1 %
- Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
Row Splitter (deprecated)< 1 %- Pivot< 1 %
- String Splitter (Regex)< 1 %
- String Replacer< 1 %
- Ungroup< 1 %
- Rule-based Row Filter< 1 %
- Rule-based Row Splitter< 1 %
- Empty Table Switch< 1 %
- Table Editor (JavaScript)< 1 %
- String to JSON< 1 %
- JSON to Table< 1 %
Python Script (1⇒1)< 1 %- GET Request< 1 %
- String to Date&Time< 1 %
- XPath< 1 %
- Collection to String< 1 %
- Binary Objects to Strings< 1 %
- String to URI< 1 %
- Line Reader< 1 %
- Table Reader< 1 %
Table Reader< 1 %- Table Row to Variable Loop Start< 1 %
- Column Resorter< 1 %
- Partitioning< 1 %
- Column Splitter< 1 %
- Unpivot< 1 %
- IF Switch< 1 %
- Math Formula (Multi Column)< 1 %
- Excel Reader< 1 %
- Document Viewer< 1 %
- Date&Time to String< 1 %
- HTTP Result Data Extractor< 1 %
- Page Source< 1 %
- HTML Node to Text< 1 %
- Recursive Loop Start< 1 %
- Python Script (legacy)< 1 %
- Decision Tree to Ruleset< 1 %
- Number Rounder< 1 %
- Recursive Loop End< 1 %
Table Row to Variable< 1 %Variable to Table Row< 1 %- Missing Value (Apply)< 1 %
- Snowball Stemmer< 1 %
- Active Branch Inverter< 1 %
- Inject Variables (Data)< 1 %
Recursive Loop End< 1 %- String Configuration< 1 %
- Container Input (Table)< 1 %
- Moving Aggregator< 1 %
- Number Formatter< 1 %
- Extract URI Info< 1 %
Table Row To Variable Loop Start< 1 %CSV Reader< 1 %- Column Auto Type Cast< 1 %
- Shuffle< 1 %
Excel Reader (XLS)< 1 %- Term to String< 1 %
- Date Extractor< 1 %
IF Switch (Flow Variable Value)< 1 %- Split Collection Column< 1 %
- Variable to Table Column< 1 %
Recursive Loop Start< 1 %- Cell Splitter By Position< 1 %
- Path to URI< 1 %
- String to Path< 1 %
- Tagged Document Viewer< 1 %
- List Remote Files (legacy)< 1 %
Variable to Table Column< 1 %Generic Loop Start< 1 %- Cache< 1 %
- Tag Filter< 1 %
- Tag Stripper< 1 %
- Flat File Document Parser< 1 %
- RSS Feed Reader< 1 %
- Google Sheets Reader< 1 %
- Column Selection Configuration< 1 %
- Column Selection Widget< 1 %
- Duration to String< 1 %
- Remove Empty Rows< 1 %
- N-Gram Extractor< 1 %
- Hash Calculator< 1 %
RMSE Calculator< 1 %- Threshold Analyzer< 1 %
- HTTP Retriever< 1 %
- URI to String< 1 %
Line Reader< 1 %- Variable Creator< 1 %
Recursive Loop End (2 ports)< 1 %Cell Replacer< 1 %- Rule Engine (Dictionary)< 1 %
- End IF< 1 %
- Merge Variables< 1 %
- Counter Generation< 1 %
- Case Converter< 1 %
- Dictionary Filter< 1 %
- Replacer< 1 %
- Word Parser< 1 %
- OpenNLP NE Tagger< 1 %
- Sentence Extractor< 1 %
- Container Input (Row)< 1 %
Extract Date&Time Fields< 1 %- Date&Time Part Extractor< 1 %
- Date&Time Shift< 1 %
- Table to HTML String< 1 %
- URL Domain Extractor< 1 %
- URL Normalizer< 1 %
Table Extractor< 1 %
Views
- This node has no views
Workflows
20220503_filter_rows_stopwordsKNIME Forum- 24245-1-1KNIME Forum
- 31501_regex_matcherKNIME Hub
- 31892-struggling-to-split-cellKNIME Hub
- Add filename to column headersKNIME Hub
- Show all 82 workflows
Links
- Ka-Boom! Palladian 2.0by qqilihq on 2020-01-27forum.knime.com/p/79848
- String Manipulation Regex?by qqilihq on 2020-02-18forum.knime.com/p/81851
- Pattern sequence string recognition and extractionby armingrudd on 2020-05-30forum.knime.com/p/92921
- Extract first number from stringby armingrudd on 2020-01-28forum.knime.com/p/79975
- Regular expression helpby qqilihq on 2020-04-09forum.knime.com/p/86981
- Show all 48 links
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.