This node splits the string content of a selected column into logical groups using regular expressions. A capturing group is usually identified by a pair of parentheses, whereby the pattern in such parentheses is a regular expression. Optionally, a group can be named. See Pattern for more information. For each input, the capture groups are the output values. Those can be appended to the table in different ways; by default, every group will correspond to one additional output column.
A short introduction to groups and capturing is given in the Java API . Some examples are given below:
Parsing Patent Numbers
Patent identifiers such as "US5443036-X21" consisting of
a (at most) two-letter country code ("US"), a patent
number ("5443036") and possibly some application code
("X21"), which is separated by a dash or a space
character, can be grouped by the expression
([A-Za-z]{1,2})([0-9]+)[ \-]?(.*$).
Each of the parenthesized terms corresponds to the
aforementioned properties. For named output columns,
we can add group names to the pattern:
(?<CC>[A-Za-z]{1,2})is now identified with "CC" in the output.(?<patentNumber>[0-9]+)is now identified with "patentNumber".[ \-]?is and was never a capturing group so it remains unchanged.(?<applicationCode>.*$)is now identified with "applicationCode".
Strip File URLs
This is particularly useful when this node is used to
parse the file URL of a file reader node (the URL is
exposed as a flow variable and then exported to a table
using a Variable to Table node). The format of such
URLs is similar to "file:c:\some\directory\foo.csv".
Using the pattern
[A-Za-z]*:(.*[/\\])(?<filename>([^\.]*)\.(.*$))
generates four groups: The first group identifies the directory
and is denoted by (.*[/\\]). It consumes all characters
until a final slash or backslash is encountered; in the example,
this refers to "c:\some\directory\". The second group
represents the file name, whereby it encapsulates the
third and fourth group. The third group (([^\.]*))
consumes all characters after the directory,
which are not a dot '.' (which is "foo" in the
above example). The pattern expects a single dot
(final which is ignored) and finally the fourth group (.*$),
which reads until the end of the string and indicates
the file suffix ('csv'). The groups for the above
example are
- Group 1: c:\some\directory
- Group filename: foo.csv
- Group 3: foo
- Group 4: csv
Email Address Extraction
Let's consider a scenario where you have a list of email addresses.
Using the pattern (?<username>.+)@(?<domain>.+),
you can extract the username and domain from the addresses.
The groups for the email address "john.doe@example.com" are:
- Group username: john.doe
- Group domain: example.com
Options
Popular Predecessors
Excel Reader (XLS)5 %Cell Splitter4 %Row Filter (deprecated)4 %- String Manipulation3 %
- Path to String3 %
Variable to Table Row3 %- Column Filter3 %
- String Splitter (Regex)3 %
- Excel Reader2 %
Variable to Table Column2 %- Cell Splitter2 %
- CSV Reader2 %
Row Splitter (deprecated)2 %- Joiner1 %
- Table Creator1 %
Column Rename1 %- Rule Engine1 %
Line Reader1 %- Column Splitter1 %
Number To String1 %- Column Expressions1 %
- GroupBy1 %
Concatenate (Optional in)< 1 %- Rule-based Row Filter< 1 %
- Column Name Extractor< 1 %
- Concatenate< 1 %
Excel Reader (XLS)< 1 %- Math Formula< 1 %
- File Reader< 1 %
- Rule-based Row Splitter< 1 %
- Loop End< 1 %
- Variable to Table Row< 1 %
- Missing Value< 1 %
Loop End< 1 %String To Number< 1 %- List Files/Folders< 1 %
Joiner< 1 %- Unpivot< 1 %
Variable to Table Column< 1 %List Files< 1 %- String Replacer< 1 %
Table Reader< 1 %- Table Transposer< 1 %
Excel Reader (XLS)< 1 %- String to Path< 1 %
- Column Renamer< 1 %
- Java Snippet< 1 %
Column Appender< 1 %Regex Extractor< 1 %- Table Manipulator< 1 %
- Constant Value Column< 1 %
CASE Switch Data (Start)< 1 %Cell Replacer< 1 %- RowID< 1 %
- Sorter< 1 %
- PDF Parser< 1 %
- RDKit Canon SMILES< 1 %
- Reference Column Filter< 1 %
- Regex Extractor< 1 %
- Cell Splitter By Position< 1 %
- Column Resorter< 1 %
XLS Reader< 1 %Python Script (1⇒1)< 1 %- String Manipulation (Multi Column)< 1 %
- Split Collection Column< 1 %
- Column Merger< 1 %
- String Input (legacy)< 1 %
- File Meta Info (legacy)< 1 %
- Duplicate Row Filter< 1 %
- DB Reader< 1 %
CSV Reader< 1 %Database Reader< 1 %- Reference Row Filter< 1 %
- Row Sampling< 1 %
- JSON Path< 1 %
- PDB Property Extractor< 1 %
- Line Reader< 1 %
Database Connection Table Reader< 1 %- Missing Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Pivot< 1 %
- Ungroup< 1 %
- Date&Time to String< 1 %
- String to Number< 1 %
- Column Renamer (Dictionary)< 1 %
- Load Text Files< 1 %
- List Folders< 1 %
- Create Collection Column< 1 %
- List Remote Files (legacy)< 1 %
- Column List Loop Start< 1 %
- Group Loop Start< 1 %
Recursive Loop End< 1 %- Column Aggregator< 1 %
- Nominal Value Row Filter< 1 %
- Reference Row Splitter< 1 %
- Empty Table Switch< 1 %
Excel Writer (XLS)< 1 %Document Data Extractor< 1 %- Term to String< 1 %
XML Reader< 1 %- Binary Objects to Strings< 1 %
- Number to String< 1 %
- Lag Column< 1 %
- End IF< 1 %
- Web Log Reader< 1 %
- URL Domain Extractor< 1 %
- Variable to Table Column< 1 %
- Counter Generation< 1 %
- Column Selection Configuration< 1 %
- Python Script (legacy)< 1 %
- CASE Switch Start< 1 %
- List Box Configuration< 1 %
- Run Garbage Collector< 1 %
- Unzip Files (legacy)< 1 %
- URL to File Path< 1 %
Table Row To Variable Loop Start< 1 %File Reader< 1 %- Chunk Loop Start< 1 %
- Case Converter< 1 %
- Column Auto Type Cast< 1 %
- Column Combiner< 1 %
- Column Rename (Regex)< 1 %
- Cross Joiner< 1 %
- Double to Integer< 1 %
- Missing Value (Apply)< 1 %
- String Manipulation (Variable)< 1 %
- Index Query< 1 %
- RegEx Filter< 1 %
- Tika Parser< 1 %
- Document Data Extractor< 1 %
- Sentence Extractor< 1 %
Strings To Document< 1 %- Column Filter (legacy)< 1 %
- JSON to Table< 1 %
- GET Request< 1 %
- Legacy Date&Time to Date&Time< 1 %
- String to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
- XPath< 1 %
- HTTP Result Data Extractor< 1 %
- Row Filter (Labs)< 1 %
- Value Counter< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- DB Query Reader< 1 %
- Value Filter (legacy)< 1 %
- Webpage Retriever< 1 %
- HTML Node to Text< 1 %
- Table Row to Variable< 1 %
- File Reader (Complex Format)< 1 %
- Variable Condition Loop End< 1 %
- Recursive Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
- Column Appender< 1 %
- Rule Engine Variable< 1 %
- Variable Expressions< 1 %
- Files/Folders Meta Info< 1 %
- Path to String (Variable)< 1 %
- Path to URI< 1 %
- Date&Time Part Extractor< 1 %
- Extract Context Properties< 1 %
- Columns to JSON< 1 %
- URI to String< 1 %
- URL to File Path (Variable)< 1 %
Recursive Loop Start< 1 %- Domain Calculator< 1 %
- Extract Table Spec< 1 %
Extract Outer/InnerHTML< 1 %Table Column to Variable< 1 %- Java Edit Variable< 1 %
Loop End (2 ports)< 1 %- Column to Grid< 1 %
- Many to One< 1 %
- Reference Column Splitter< 1 %
- Column Selection (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Labeling Properties< 1 %
- Table to String< 1 %
- Partitioning< 1 %
- Molecule Type Cast< 1 %
- SDF Reader< 1 %
- Twitter Timeline< 1 %
- Create Directory (legacy)< 1 %
- Download (legacy)< 1 %
Variable to Table Row< 1 %- Rule Engine (Dictionary)< 1 %
- Twitter Search< 1 %
Extract Attribute< 1 %- List Files with Authentication< 1 %
- Extract Missing Value Cause< 1 %
- Expand Barcode< 1 %
- String to URI< 1 %
- Try (Data Ports)< 1 %
Database Looping< 1 %Generic Loop Start< 1 %- Filter Apply Row Splitter< 1 %
- Number Rounder< 1 %
- Java Snippet (simple)< 1 %
- Bag Of Words Creator< 1 %
- String to Term< 1 %
- Don't Save End< 1 %
Extract Date&Time Fields< 1 %- Moving Aggregator< 1 %
- Molecule to CDK< 1 %
- Load text-based files< 1 %
Python Snippet< 1 %- Extract URI Info< 1 %
Table Row to Variable< 1 %Line Reader< 1 %Recursive Loop End (2 ports)< 1 %- Numeric Binner< 1 %
- Expand Byte Vector< 1 %
- Column Comparator< 1 %
String Replace (Dictionary)< 1 %- Crosstab< 1 %
- Empty Table Creator< 1 %
- Similarity Search< 1 %
- OpenBabel< 1 %
- Flat File Document Parser< 1 %
- Column Filter Configuration< 1 %
- Date&Time Difference< 1 %
- Window Loop Start< 1 %
- String to Date/Time (legacy)< 1 %
- Load FASTA Files< 1 %
- Load Layout< 1 %
- Create Well Position< 1 %
- Catch Errors (Data Ports)< 1 %
- Table Reader< 1 %
- Extract Table Dimension< 1 %
- Find Elements< 1 %
- Naming< 1 %
- Files to Binary Objects< 1 %
- Inject Variables (Data)< 1 %
- Read Images< 1 %
Parameterized Database Query< 1 %- Fixed Width File Reader< 1 %
Scorer< 1 %- Table Validator (Reference)< 1 %
- Constant Value Column Filter< 1 %
- Cache< 1 %
Read Excel Sheet Names (XLS)< 1 %- Java Snippet Row Filter< 1 %
- NGram Creator< 1 %
Stop Word Filter< 1 %- Strings to Document< 1 %
Python Script (1⇒1)< 1 %Python Source< 1 %- Python Source (legacy)< 1 %
- R Snippet< 1 %
- Triple File Reader< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Extract Time Window (legacy)< 1 %
- HTTP Retriever< 1 %
- HTML Parser< 1 %
- Quit WebDriver< 1 %
- Molecule Properties< 1 %
- Canonical SMILES< 1 %
- Timed Loop End (1 port)< 1 %
- Load Local XML Files< 1 %
- Benchmark End< 1 %
- Normalize Plates (Z-Score)< 1 %
- Binary Objects to PNGs< 1 %
- Copy/Move Files (legacy)< 1 %
Table Row to Variable< 1 %- Loop End (Column Append)< 1 %
Counting Loop Start< 1 %Interval Loop Start< 1 %- Random Forest Learner (Regression)< 1 %
- Category to Number< 1 %
- Table Validator< 1 %
- Equal Size Sampling< 1 %
- HiLite Row Splitter< 1 %
- Row Splitter (Labs)< 1 %
- Normalizer< 1 %
Number To String (PMML)< 1 %- Rank< 1 %
- Statistics< 1 %
- IF Switch< 1 %
- Color Manager< 1 %
- Save Workflow< 1 %
- Spark to Table< 1 %
- Parallel Chunk Start< 1 %
- One Row to Many< 1 %
- Random Label Assigner< 1 %
- Math Formula (Variable)< 1 %
- Java IF (Table)< 1 %
- Java Snippet Row Splitter< 1 %
- String Matcher< 1 %
- Tika Language Detector< 1 %
- Tika Parser URL Input< 1 %
- Dictionary Replacer (File-based)< 1 %
- N Chars Filter< 1 %
- Number Filter< 1 %
- Punctuation Erasure< 1 %
- Replacer< 1 %
- Google Analytics Query (legacy)< 1 %
- Google Sheets Reader< 1 %
- Date&Time Configuration< 1 %
- Table Editor (JavaScript)< 1 %
- File Chooser Widget< 1 %
- Image Converter< 1 %
- Node Table< 1 %
- SPARQL Query< 1 %
- Modify Time< 1 %
- Remove Empty Rows< 1 %
- Fingerprint Similarity< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit Count-Based Fingerprint< 1 %
- RDKit Fingerprint< 1 %
- List to FlowVariable< 1 %
- Chunk Loop Run-to-time Loop Start< 1 %
Table Column to Variable< 1 %- Table Column to Variable< 1 %
Recursive Loop Start (2 ports)< 1 %- Add Empty Rows< 1 %
- Create Table Structure< 1 %
- Number to String (PMML)< 1 %
- String to Number (PMML)< 1 %
- Nominal Probability Distribution Creator< 1 %
- Set Operator< 1 %
- Top k Row Filter< 1 %
- Decision Tree to Ruleset< 1 %
- Shape Manager< 1 %
- Parallel Chunk End< 1 %
- POS Tagger< 1 %
- Tag Cloud (JavaScript)< 1 %
- Container Input (JSON)< 1 %
- Tess4J< 1 %
- Create Date&Time Range< 1 %
- RDKit Descriptor Calculation< 1 %
- Extract Text< 1 %
Views
- This node has no views
Workflows
01_AK_generate_html_from_picturesKNIME Forum- 01_Clickstream_AnalysisKNIME Hub
- 01_DataIntegrationKNIME Hub
- 01_SDS phrases extractionKNIME Hub
- 01_SDS phrases extractionKNIME Hub
- Show all 264 workflows
Links
- Daten splittenby knimediger on 2020-09-24forum.knime.com/p/103941
- How to split with Regexby armingrudd on 2019-05-19forum.knime.com/p/60767
- Regular expression helpby qqilihq on 2020-04-09forum.knime.com/p/86981
- Regex Coding for Text to Column splittingby danielesser on 2020-11-13forum.knime.com/p/108079
- How do I pull a string given varying input valuesby JanDuo on 2020-07-13forum.knime.com/p/96720
- Show all 14 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.