Icon

Various Examples of Regex in KNIME

There has been no description set for this workflow's metadata.

Regex Matching Regex Extracting Regex Filtering Regex Replacing Regex Splitting Regex Extracting: Capturing Context of Words Regex Replacing: Removing consecutive duplicate words Regex Matching: Dealing with Line Breaks generates empty value rows AND multiple occurences[0-9]+blob of text in one rowfor ease of viewinggenerates missing value rows, but ONLY first occurence; uses regex capture groupscolumn("Your Column").match(/([0-9]{4})/)[0]regexReplacer()regexReplace($Your Column$, "[0-9]{4}", "")collection to columnsfilter columns with regex.+MATCHES$Your Column$ MATCHES ".*[0-9]{4}.*" =>"match"regexMatcher()regexMatcher($Your Column$, ".*[0-9]{4}.*")remove non-matching rowswith regular expressions.*[0-9]{4}.*does NOT generate missing value rows; uses regex capture groupsregexReplace($Your Column$, "(.*)([0-9]{4})(.*)", "$2")Use capture groups to split datawith escape character (backslash)(.*)\.(.*)data withline breaksregexMatcher() - ignore case (?i) ; consider line breaksregexMatcher($Your Column$, "(?i)[\\s\\S]*(pol|pl)[\\s\\S]*")capture context of word in between the \s.{10}\sin\s.{10}collection to columnsregexReplacer()regexReplace($column_name$, "(?i)\\b([a-z]+)\\b(?:\\s+\\1\\b)+", "$1")Regex Find All Table Creator Table View Column Expressions String Manipulation Table Creator Split CollectionColumn Column Filter Rule Engine String Manipulation Row Filter String Manipulation Regex Split Excel Reader String Manipulation Regex Find All Split CollectionColumn String Manipulation Regex Matching Regex Extracting Regex Filtering Regex Replacing Regex Splitting Regex Extracting: Capturing Context of Words Regex Replacing: Removing consecutive duplicate words Regex Matching: Dealing with Line Breaks generates empty value rows AND multiple occurences[0-9]+blob of text in one rowfor ease of viewinggenerates missing value rows, but ONLY first occurence; uses regex capture groupscolumn("Your Column").match(/([0-9]{4})/)[0]regexReplacer()regexReplace($Your Column$, "[0-9]{4}", "")collection to columnsfilter columns with regex.+MATCHES$Your Column$ MATCHES ".*[0-9]{4}.*" =>"match"regexMatcher()regexMatcher($Your Column$, ".*[0-9]{4}.*")remove non-matching rowswith regular expressions.*[0-9]{4}.*does NOT generate missing value rows; uses regex capture groupsregexReplace($Your Column$, "(.*)([0-9]{4})(.*)", "$2")Use capture groups to split datawith escape character (backslash)(.*)\.(.*)data withline breaksregexMatcher() - ignore case (?i) ; consider line breaksregexMatcher($Your Column$, "(?i)[\\s\\S]*(pol|pl)[\\s\\S]*")capture context of word in between the \s.{10}\sin\s.{10}collection to columnsregexReplacer()regexReplace($column_name$, "(?i)\\b([a-z]+)\\b(?:\\s+\\1\\b)+", "$1")Regex Find All Table Creator Table View Column Expressions String Manipulation Table Creator Split CollectionColumn Column Filter Rule Engine String Manipulation Row Filter String Manipulation Regex Split Excel Reader String Manipulation Regex Find All Split CollectionColumn String Manipulation

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: victorpalacios
Created at: 2022-02-18
On NodePit since: 2022-03-22
Last update: 2024-04-26
Created with KNIME version: v4.5.2
Tags: REGEX

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

Try NodePit Runner!