Remove all duplicate items in a string

Force all columns to be read as strings (use KNIME nodes only)

Ever got annoyed that you cannot join two datasets on strings because they aren't an exact match? Fuzzy matching to the rescue! T…

Ever got annoyed that you cannot join two datasets on strings because they aren't an exact match? Fuzzy matching to the rescu…

This workflow allows the user to select a disease from ChEMBL DB and perform a search of every target (single protein or protein …

replace several blanks with a flexible number of blanks ....

replace several missings in string replace(column("Column1"), " "," ")

Search if a text ends with a specific string - find last part after a certain character

Match similar addresses from one list together into similar groups

simple date string conversions

Force R’s readr to import all columns of a messy CSV file as strings - allow changing table structures ——— library(readr) file_lo…

address deduplication, string similarity and fingerprinting (a collection) A few links and ressources I collected about address d…

use R to list excel sheet names, extract the data and keep only columns that are present in all sheets use R package readxl to li…

Find a pattern in a string with a combination of Java or R

A meta collection about handling data and time functions in KNIME, R and SQL (including databases and big data systems) Node Guid…

convert excel number (or string) to date

Demonstrates a simple if then else syntax in Java Snippet (Simple). Also doing a double to string conversion.

Force R’s readr to import all columns as strings ——— library(readr) file_location <- knime.flow.in[["Location"]] knime.out <- as.…

see what you can do with dates as data values, strings and numbers. You can transform them and store them as String or number and…

extract the last 4 characters from a string substr(column("column1"),length(column("column1"))-4 , 4)