Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
Sign in
  • KNIME Hub
  • Nodes
  • String Manipulation
NodeNode / Manipulator

String Manipulation

streamable

Manipulates strings like search and replace, capitalize or remove leading and trailing white spaces.

Examples:

To remove leading and trailing blanks from a column with name c0 you would use the expression:
strip($c0$)

If you have your customer names in column names with titles Mr and Mister and you want to normalize the data so that only Mr is used you could use the expression:
replace($names$, "Mister", "Mr")
or you could combine it to
replace(replace($names$, "Mister", "Mr"), "Miss", "Ms")

Or if you want to have the number of characters of the strings in a column with name text:
length($text$)

Note that strings which are part of the expression and are not from the input data (or the result of another wrapped function call) need to be enclosed in double quotes ('"'). Additionally, if the string contains a quote character, it must be escaped using a backslash character ('\"'). Finally, other special characters such as single quotes and backslashes need to be escaped using a backslash. For instance, a single backslash in a string is written as two consecutive backslash characters; the first one acts as the escape character for the second.

Node details

Input ports
  1. Type: Table
    Input table
    Input table.
Output ports
  1. Type: Table
    Appended table
    Input table with an additional calculated column or one column replaced.

Extension

The String Manipulation node is part of this extension:

Related workflows & nodes

  1. Combine Date and Time
    There has been no description set for this workflow's metadata.
    simons > Public > Forum > Date&Time > Combine_Date_And_Time
  2. String Manipulation, Math Formula and Rule Engine Example
    ETL data manipulation string manipulation +7
    This workflow shows three different data manipulation operations, namely: - create three categories of people based on …
    knime > Examples > 02_ETL_Data_Manipulation > 04_Transformation > 02_StringManipulation_MathFormula_RuleEngine
  3. Dose Response Curves with HCS-Tools
    High-content screening
    The workflow shows how the 'Dose Response' node from the HCS-Tools plugin can be used to calculate dose response models…
    knime > Examples > 99_Community > 02_HCS_Tools > 05_Dose_Response
  4. RegEx extract
    mw > Public > Knime Forum Support > RegEx extract
  5. Use Java and Regex to extract the last portion of a ID number
    java r regex +6
    Find a pattern in a string with a combination of Java or R
    mlauber71 > Public > kn_example_text_number_value_regex
  6. Z_018_timestamp
    tommy > Public > Z_018_timestamp
  7. create_job_and_execute
    ana_ved > Public > create_job_and_execute
  8. Column Expressions for Data Manipulation
    ETL data manipulation data transformation +8
    This is an example worklow to manipulate string values, transform numeric values, and generate new columns using the fo…
    knime > Examples > 02_ETL_Data_Manipulation > 04_Transformation > 03_Column_Expressions_for_Data_Manipulation
  9. Numeric Outliers simple example
    IQR Numeric Outliers Outlier
    This node shows how KNIME can identify outliers using the standard approach with Interquartile Range (IQR).
    scottf > Public > ForumWorkflows > 2020 > 01 > Numeric_Outliers_Simple_Example
  10. find average date
    date average
    find average date
    mlauber71 > Public > forum > kn_forum_average_date

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 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 Server
© 2021 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits