Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • mlauber71
  • Spaces
  • Public
  • kn_example_regex_match_words
WorkflowWorkflow

RegEx match complete word with special characters - using Rule Engine, Column Expressions, String Manipulation, and Java Snippets

Regex String Search Java RegexMatcher
+5
mlauber71 profile image

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
RegEx match complete word with special characters ------------------ Rule Engine $my_text$ MATCHES /^.*(S\\.A\\.S\\.).*$/ => "contains S.A.S." Column Expressions else if (regexMatcher(column("my_text"), "^.*(S\.A\.S\.).*$")) {true} String Manipulation regexMatcher($my_text$, "^.*(S\.A\.S\.).*$") Java Snippet (simple) Pattern p = Pattern.compile("(^.*)(S\.A\.S\.)(.*$)"); Matcher m = p.matcher($my_text$); Java Snippet Pattern p = Pattern.compile("^.*(S\\.A\\.S\\.).*$"); Matcher m = p.matcher(c_my_text);

External resources

  • RegEx - remove line breaks and special characters from column name
  • KNIME and Java - simple if then else - with some string conversion
  • hayasaka - Various Examples of Regex in KNIME
  • victor_palacios - Various Examples of Regex in KNIME
  • more RegEx examples from the KNIME hub
  • Component by takbb - Regex String Replacer
  • Component by takbb - Regex String Stripper
  • Component by natanaeldgsantos - Regex Find All
  • (48551) - forum entry

Used extensions & nodes

Created with KNIME Analytics Platform version 4.6.3
  • Go to item
    KNIME Base nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.6.2

    knime
  • Go to item
    KNIME Expressions Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.6.0

    knime
  • Go to item
    KNIME Javasnippet Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.6.0

    knime
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item
Loading deployments
Loading ad hoc executions

Legal

By using or downloading the workflow, you agree to our terms and conditions.

Discussion
Discussions are currently not available, please try again later.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits