Icon

01_​Various_​Examples_​of_​Regex_​in_​KNIME

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 This workflow demonstrates various examples of Regex. Generates empty value rows and multiple occurences[0-9]+- g enerates missing value rows, but only first occurence; - uses regex capture groups.column("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 groups.regexReplace($Your Column$, "(.*)([0-9]{4})(.*)", "$2")Use capture groups to split datawith escape character (backslash):(.*)\.(.*)Regex Find All Column Expressions String Manipulation Table Creator Split CollectionColumn Column Filter Rule Engine String Manipulation Row Filter String Manipulation Regex Split Regex Matching Regex Extracting Regex Filtering Regex Replacing Regex Splitting This workflow demonstrates various examples of Regex. Generates empty value rows and multiple occurences[0-9]+- g enerates missing value rows, but only first occurence; - uses regex capture groups.column("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 groups.regexReplace($Your Column$, "(.*)([0-9]{4})(.*)", "$2")Use capture groups to split datawith escape character (backslash):(.*)\.(.*)Regex Find All Column Expressions String Manipulation Table Creator Split CollectionColumn Column Filter Rule Engine String Manipulation Row Filter String Manipulation Regex Split

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: 2023-04-06
Last update: 2024-04-26
Created with KNIME version: v4.7.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!