0 ×

String Manipulation (Variable)

KNIME Java Snippet Nodes version 4.0.0.v201906131505 by KNIME AG, Zurich, Switzerland

Manipulates or defines values of variables like search and replace, capitalize or remove leading and trailing white spaces.

Examples:

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

If you have your customer names in flow variable 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($${Snames}$$, "Mister", "Mr")
or you could combine it to
replace(replace($${Snames}$$, "Mister", "Mr"), "Miss", "Ms")

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

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.

Options

Flow Variable List: The list contains the flow variables that are currently available at the node input. Double clicking any of the entries will insert the respective identifier at the current cursor position (replacing the selection, if any).
Function: Select a single function to display its description. A double click will insert the function in the expression editor. It will replace your current selection or simply insert at the current caret position. Select a category to narrow down the list of displayed functions.
Expression: The place for your business logic. You can hit ctrl+space to get an auto completion box.
Replace/Append: Specify here if you want the result to be put into a separate or existing flow variable. Note that the flow variable only can be replaced, if the type of it does not change (otherwise there will a new flow variable be appended, with same name, but different type).
Syntax check on close: If unchecked the dialog can be closed even when the expression has syntax errors.

Input Ports

: Input variables (optional).

Output Ports

: Input variables with an additional calculated variable or one variable replaced.

Best Friends (Incoming)

Table Row to Variable (15 %)
Table Row To Variable Loop Start (10 %)
String Manipulation (Variable) (10 %)
String Input (5 %)
Merge Variables (4 %)
Table Column to Variable (3 %)
Column List Loop Start (2 %)
Excel Writer (XLS) (2 %)
CSV Writer (2 %) Streamable
Rule Engine Variable (2 %)
Date&Time Input (1 %)
Math Formula (Variable) (1 %)
Create Directory (1 %)
Group Loop Start (1 %)
String Manipulation (1 %) Streamable
Loop End (1 %)
Java Edit Variable (1 %)
Flow Variable IF Switch (< 1 %)
Extract Context Properties (< 1 %)
List Files (< 1 %)
CASE Switch Variable (Start) (< 1 %)
Extract Variables (Data) (< 1 %)
Column Filter (< 1 %) Streamable
URL to File Path (Variable) (< 1 %)
Table Writer (< 1 %)
Row Filter (< 1 %) Streamable
GroupBy (< 1 %)
Column Rename (< 1 %) Streamable
Create File Name (< 1 %)
Database Writer (legacy) (< 1 %) Streamable
Column Resorter (< 1 %) Streamable
Joiner (< 1 %)
Create Temp Dir (< 1 %)
Math Formula (< 1 %) Streamable
Flow Variable IF Switch (Flow Variable Value) (< 1 %)
Counting Loop Start (< 1 %)
Chunk Loop Start (< 1 %)
Excel Reader (XLS) (< 1 %) Streamable
Single Selection (< 1 %)
Try (Variable Ports) (< 1 %)
File Reader (< 1 %) Streamable
IF Switch (< 1 %)
Integer Input (< 1 %)
Column Selection (< 1 %)
Value Selection (< 1 %)
R Snippet (< 1 %)
Get Storage Path (< 1 %)
Inject Variables (Data) (< 1 %)
Variable to Table Row (< 1 %)
CSV Reader (< 1 %)
SQL Extract (legacy) (< 1 %)
Loop End (2 ports) (< 1 %)
Interval Loop Start (< 1 %)
Concatenate (< 1 %) Streamable
Extract Column Header (< 1 %)
Constant Value Column (< 1 %) Streamable
Partitioning (< 1 %)
Sorter (< 1 %)
Transpose (< 1 %)
Rule-based Row Filter (< 1 %) Streamable
WAV Reader (< 1 %)
Load Configuration (< 1 %)
Flow Variable End IF (< 1 %)
Upload (< 1 %)
Catch Errors (Data Ports) (< 1 %)
Variable to Table Column (< 1 %) Streamable
Database Reader (legacy) (< 1 %)
Database SQL Executor (legacy) (< 1 %)
Generic Loop Start (< 1 %)
Recursive Loop Start (< 1 %)
Variable Loop End (< 1 %)
Concatenate (Optional in) (< 1 %) Streamable
Numeric Binner (< 1 %) Streamable
Column Combiner (< 1 %) Streamable
Column Aggregator (< 1 %) Streamable
Column Appender (< 1 %) Streamable
Column Rename (Regex) (< 1 %) Streamable
Missing Value (< 1 %)
String Replacer (< 1 %) Streamable
Ungroup (< 1 %) Streamable
CASE Switch Variable (End) (< 1 %)
Empty Table Switch (< 1 %)
End IF (< 1 %)
Extract Table Dimension (< 1 %)
Line Chart (JFreeChart) (< 1 %)
Java Edit Variable (simple) (< 1 %)
Boolean Input (< 1 %)
Credentials Input (< 1 %)
~~Date Input~~ (< 1 %) Deprecated
Container Input (Variable) (< 1 %)
Parameter Optimization Loop Start (< 1 %)
Python Script (1⇒1) (< 1 %)
String to Date&Time (< 1 %) Streamable
Create Date&Time Range (< 1 %)
Window Loop Start (< 1 %)
XML Reader (< 1 %)
KNIME Server Connection (< 1 %)
~~Flow Variable IF Switch (Flow Variable Value)~~ (< 1 %) Deprecated
Table Row To Variable Run-to-time Loop Start (< 1 %)
Read Variables (< 1 %)
Plate Heatmap Viewer (< 1 %)
Create Collection Column (< 1 %) Streamable
Split Collection Column (< 1 %)
Delete Files (< 1 %)
FTP Connection (< 1 %)
String to URI (< 1 %)
Wait... (< 1 %)
Active Branch Inverter (< 1 %)
Database Query (legacy) (< 1 %)
Database Row Filter (legacy) (< 1 %)
Database Table Selector (legacy) (< 1 %)
Table Reader (< 1 %) Streamable
Table Creator (< 1 %)
Loop End (Column Append) (< 1 %)
Recursive Loop End (< 1 %)
~~Naive Bayes Learner~~ (< 1 %) Deprecated
Decision Tree Predictor (< 1 %)
~~K Nearest Neighbor~~ (< 1 %) StreamableDeprecated
~~Numeric Scorer~~ (< 1 %) Deprecated
Gradient Boosted Trees Learner (< 1 %)
~~Number To String~~ (< 1 %) Deprecated
~~String To Number~~ (< 1 %) StreamableDeprecated
Lag Column (< 1 %) Streamable
Linear Correlation (< 1 %)
Cross Joiner (< 1 %) Streamable
Row Splitter (< 1 %) Streamable
Pivoting (< 1 %)
RowID (< 1 %) Streamable
Column Splitter (< 1 %) Streamable
Target Shuffling (< 1 %)
Value Counter (< 1 %)
Renderer to Image (< 1 %)
Rule Engine (< 1 %) Streamable
Rule-based Row Splitter (< 1 %) Streamable
Rule Engine Variable (Dictionary) (< 1 %)
CASE Switch Data (End) (< 1 %)
Cache (< 1 %)
Extract Table Spec (< 1 %)
Scatter Matrix (local) (< 1 %)
PMML to SQL (< 1 %)
SDF Reader (< 1 %)
SDF Writer (< 1 %)
Amazon S3 File Picker (< 1 %)
Azure Blob Store File Picker (< 1 %)
Parallel Chunk Start (< 1 %)
SQLite Connector (legacy) (< 1 %)
TensorFlow Network Writer (< 1 %)
Autocomplete Text Input (< 1 %)
Bar Chart (JavaScript) (< 1 %)
Explorer Browser (< 1 %)
Call Local Workflow (Row Based) (< 1 %)
H2O to Table (< 1 %)
H2O Model to MOJO (< 1 %)
Item Set Finder (Borgelt) (< 1 %)
Math Formula (Multi Column) (< 1 %) Streamable
HeatMap (JFreeChart) (< 1 %)
~~Excel Reader (XLS)~~ (< 1 %) StreamableDeprecated
Excel Sheet Appender (XLS) (< 1 %)
Java Snippet (simple) (< 1 %)
Send to Tableau Server (< 1 %)
Column Filter (< 1 %)
Value Filter (< 1 %)
Double Input (< 1 %)
File Upload (< 1 %)
List Box Input (< 1 %)
Multiple Selections (< 1 %)
Generic JavaScript View (< 1 %)
JSON Path (< 1 %) Streamable
~~Python Edit Variable~~ (< 1 %) Deprecated
Python Script (1⇒2) (< 1 %)
Python Source (< 1 %)
Python Edit Variable (< 1 %)
~~Integer Input (legacy)~~ (< 1 %) Deprecated
~~String Input (legacy)~~ (< 1 %) Deprecated
Table to R (< 1 %)
Extract Date&Time Fields (< 1 %) Streamable
Date&Time Shift (< 1 %) Streamable
Date/Time Shift (legacy) (< 1 %)
Mask Date/Time (legacy) (< 1 %)
String to Date/Time (legacy) (< 1 %) Streamable
String To XML (< 1 %)
XML Writer (< 1 %)
XPath (< 1 %) Streamable
Find Elements (< 1 %)
Send Keys (< 1 %)
Show all 185 recommendations

Best Friends (Outgoing)

String Manipulation (Variable) (8 %)
CSV Writer (5 %) Streamable
Merge Variables (4 %)
Excel Writer (XLS) (3 %)
Variable to Table Row (3 %)
Create File Name (3 %)
Column Rename (3 %) Streamable
Row Filter (3 %) Streamable
Database Reader (legacy) (3 %)
Excel Sheet Appender (XLS) (2 %)
Column Filter (2 %) Streamable
Variable to Table Column (2 %) Streamable
Rule Engine (2 %) Streamable
String Manipulation (2 %) Streamable
Rule-based Row Filter (2 %) Streamable
List Files (1 %)
Table Writer (1 %)
Constant Value Column (1 %) Streamable
Column Rename (Regex) (1 %) Streamable
Image Writer (Port) (1 %)
Math Formula (1 %) Streamable
Excel Reader (XLS) (1 %) Streamable
GET Request (1 %) Streamable
File Reader (1 %) Streamable
CSV Reader (< 1 %)
Database Table Selector (legacy) (< 1 %)
Variable Loop End (< 1 %)
CASE Switch Variable (End) (< 1 %)
WrappedNode Output (< 1 %)
Rule Engine Variable (< 1 %)
Table Reader (< 1 %) Streamable
Send Email (< 1 %)
Math Formula (Variable) (< 1 %)
Flow Variable End IF (< 1 %)
Create Directory (< 1 %)
Inject Variables (Data) (< 1 %)
URL to File Path (Variable) (< 1 %)
Database Connector (legacy) (< 1 %)
Table Creator (< 1 %)
Java Snippet (< 1 %) Streamable
SDF Writer (< 1 %)
Write MDB (< 1 %)
List Remote Files (< 1 %)
Database Row Filter (legacy) (< 1 %)
Database SQL Executor (legacy) (< 1 %)
Database Writer (legacy) (< 1 %) Streamable
Java Edit Variable (< 1 %)
Row Splitter (< 1 %) Streamable
String Replacer (< 1 %) Streamable
Rule-based Row Splitter (< 1 %) Streamable
Java Edit Variable (simple) (< 1 %)
XML Reader (< 1 %)
Download (< 1 %)
Wait... (< 1 %)
Catch Errors (Var Ports) (< 1 %)
Database Table Connector (legacy) (< 1 %)
~~Numeric Scorer~~ (< 1 %) Deprecated
Joiner (< 1 %)
CASE Switch Variable (Start) (< 1 %)
IF Switch (< 1 %)
File Upload (< 1 %)
POST Request (< 1 %) Streamable
XPath (< 1 %) Streamable
Table Row to Variable (< 1 %)
Table Row To Variable Loop Start (< 1 %)
SQL Inject (legacy) (< 1 %)
Loop End (< 1 %)
Scorer (< 1 %)
Pivoting (< 1 %)
Round Double (< 1 %) Streamable
Create Temp Dir (< 1 %)
SQLite Connector (legacy) (< 1 %)
Column Expressions (< 1 %) Streamable
Index Query (< 1 %)
String Input (< 1 %)
Scorer (JavaScript) (< 1 %)
JSON Reader (< 1 %)
R View (Table) (< 1 %)
Create Date&Time Range (< 1 %)
Date&Time-based Row Filter (< 1 %) Streamable
Load Configuration (< 1 %)
IF Switch (Flow Variable Value) (< 1 %)
Flow Variable IF Switch (< 1 %)
Flow Variable IF Switch (Flow Variable Value) (< 1 %)
Read Variables (< 1 %)
Write Variables (< 1 %)
Copy/Move Files (< 1 %)
String to URI (< 1 %)
Upload (< 1 %)
Zip Files (< 1 %)
Try (Variable Ports) (< 1 %)
Database Query (legacy) (< 1 %)
Database Drop Table (legacy) (< 1 %)
Database Table Creator (legacy) (< 1 %)
Model Reader (< 1 %)
Interval Loop Start (< 1 %)
Recursive Loop Start (2 ports) (< 1 %)
Reference Column Filter (< 1 %) Streamable
Reference Row Filter (< 1 %)
RowID (< 1 %) Streamable
Column Splitter (< 1 %) Streamable
End IF (< 1 %)
Cache (< 1 %)
Parquet Writer (< 1 %) Streamable
Spark to Parquet (< 1 %)
SDF Reader (< 1 %)
Call Local Workflow (Row Based) (< 1 %)
Table to HTML (< 1 %)
Table to PDF (< 1 %)
External Tool (< 1 %)
Scatter Plot (JFreeChart) (< 1 %)
Java IF (Table) (< 1 %)
Google Sheets Reader (< 1 %)
File Download (< 1 %)
Text Output (< 1 %)
Boolean Input (< 1 %)
Date&Time Input (< 1 %)
Integer Input (< 1 %)
Table View (< 1 %)
Line Plot (< 1 %)
MongoDB Reader (< 1 %)
Call Workflow (Table Based) (< 1 %)
Python Source (< 1 %)
Python Edit Variable (< 1 %)
Modify Time (< 1 %) Streamable
StringCell To File (< 1 %) Streamable
Bash (< 1 %)
OrientDB Function (< 1 %)
Impala Connector (< 1 %)
Call Local Workflow (< 1 %)
Save Configuration (< 1 %)
Get Storage Path (< 1 %)
Database Reader (< 1 %)
Chemistry External Tool (< 1 %)
Molecule Writer (from MAE) (< 1 %)
PE ODS (< 1 %)
Database Table Exists IF Switch (< 1 %)
~~Flow Variable IF Switch (Flow Variable Value)~~ (< 1 %) Deprecated
PDB Downloader (Source) (< 1 %) Streamable
Number Formatter (< 1 %)
Dose Response (R) (< 1 %)
SendKeys (< 1 %)
List Files with Authentication (< 1 %)
Binary Objects to Files (< 1 %)
Delete Files (< 1 %)
Download / Upload from List (< 1 %)
File Meta Info (< 1 %)
FTP Connection (< 1 %)
HTTP Connection (< 1 %)
SSH Connection (< 1 %)
Unzip Files (< 1 %)
URL to File Path (< 1 %) Streamable
Table Column to Variable (< 1 %)
Image To Table (< 1 %)
Database Column Filter (legacy) (< 1 %)
Database Connection Table Reader (legacy) (< 1 %)
Database Connection Table Writer (legacy) (< 1 %)
Database Looping (legacy) (< 1 %)
Extract Context Properties (< 1 %)
Line Reader (< 1 %)
PMML Reader (< 1 %)
PMML Writer (< 1 %)
Model Writer (< 1 %)
Loop End (Column Append) (< 1 %)
Counting Loop Start (< 1 %)
Chunk Loop Start (< 1 %)
Column List Loop Start (< 1 %)
Variable Condition Loop End (< 1 %)
Recursive Loop End (< 1 %)
Recursive Loop Start (< 1 %)
Fuzzy Rule Learner (< 1 %)
Decision Tree Learner (< 1 %)
Concatenate (< 1 %) Streamable
~~Number To String~~ (< 1 %) Deprecated
~~String To Number~~ (< 1 %) StreamableDeprecated
Column Aggregator (< 1 %) Streamable
Lag Column (< 1 %) Streamable
Column Merger (< 1 %) Streamable
Column Resorter (< 1 %) Streamable
Filter Apply (< 1 %) Streamable
GroupBy (< 1 %)
Partitioning (< 1 %)
Missing Value (< 1 %)
Regex Split (< 1 %) Streamable
Rule Engine Variable (Dictionary) (< 1 %)
Extract Table Dimension (< 1 %)
Save Workflow (< 1 %)
ORC Writer (< 1 %) Streamable
Parquet Reader (< 1 %) Streamable
Hive Connector (legacy) (< 1 %)
Hive Loader (legacy) (< 1 %)
Spark Column Filter (< 1 %)
Spark SQL Query (< 1 %)
Create Spark Context (< 1 %)
Amazon S3 Connection (< 1 %)
Amazon S3 File Picker (< 1 %)
Parallel Chunk Start (< 1 %)
WrappedNode Input (< 1 %)
H2 Connector (legacy) (< 1 %)
MySQL Connector (legacy) (< 1 %)
PostgreSQL Connector (legacy) (< 1 %)
Microsoft SQL Server Connector (legacy) (< 1 %)
Microsoft SQL Server Connector (legacy) (< 1 %)
DB Table Creator (< 1 %)
Empty Table Creator (< 1 %)
Keras Input Layer (< 1 %)
Keras Network Reader (< 1 %)
DL Python Network Creator (< 1 %)
DL Python Network Executor (< 1 %)
DL Python Network Learner (< 1 %)
Autocomplete Text Input (< 1 %)
Bar Chart (JavaScript) (< 1 %)
Conditional Box Plot (< 1 %)
Pie/Donut Chart (< 1 %)
Stacked Area Chart (JavaScript) (< 1 %)
Call Local Workflow (Row Based) (< 1 %)
Dense Layer (< 1 %)
DL4J Feedforward Learner (Classification) (< 1 %)
Math Formula (Multi Column) (< 1 %) Streamable
Line Chart (JFreeChart) (< 1 %)
~~Excel Reader (XLS)~~ (< 1 %) StreamableDeprecated
Read Excel Sheet Names (XLS) (< 1 %)
TIBCO File Writer (< 1 %)
External SSH Tool (< 1 %)
String Matcher (< 1 %)
Tika Parser (< 1 %) Streamable
Wildcard Tagger (< 1 %) Streamable
External Tool (Labs) (< 1 %)
Value Filter (< 1 %)
Credentials Input (< 1 %)
File Chooser (< 1 %)
List Box Input (< 1 %)
Value Selection (< 1 %)
Line Plot (< 1 %)
Tag Cloud (< 1 %)
Container Input (Table) (< 1 %)
String to JSON (< 1 %) Streamable
JSON Path (< 1 %) Streamable
JSON Transformer (< 1 %) Streamable
Service Variable Input (< 1 %)
JSON Writer (< 1 %)
Merger (< 1 %)
Feature Value Filter (< 1 %)
~~Python Source~~ (< 1 %) Deprecated
~~Python Edit Variable~~ (< 1 %) Deprecated
Python Script (1⇒1) (< 1 %)
Python Script (2⇒1) (< 1 %)
Python Script (2⇒1) (< 1 %)
Python Script (2⇒2) (< 1 %)
~~Value Selection QuickForm (legacy)~~ (< 1 %) Deprecated
R Source (Table) (< 1 %)
R Source (Workspace) (< 1 %)
R Snippet (< 1 %)
R View (Workspace) (< 1 %)
Date&Time Difference (< 1 %) Streamable
Date&Time to String (< 1 %) Streamable
String to Date&Time (< 1 %) Streamable
Extract Date&Time Fields (< 1 %) Streamable
Date/Time Shift (legacy) (< 1 %)
Time Difference (legacy) (< 1 %)
Time Difference (legacy) (< 1 %)
Time Generator (legacy) (< 1 %)
XML Writer (< 1 %)
RDKit One Component Reaction (< 1 %)
RDKit Fingerprint (< 1 %) Streamable
ArxNode (< 1 %)
OrientDB Command (< 1 %)
~~Find Elements~~ (< 1 %) Deprecated
Find Elements (< 1 %)
Navigate (< 1 %)
Send Keys (< 1 %)
Show all 271 recommendations

Workflows

Installation

To use this node in KNIME, install KNIME Java Snippet Nodes from the following update site:

KNIME 4.0

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.