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

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

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

extract Date and Time from string

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

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

use R to convert hex to strings

RegEx match complete word with special characters ------------------ Rule Engine $my_text$ MATCHES /^.*(S\\.A\\.S\\.).*$/ => "con…

A few examples starting from a KNIME path: "knime://knime.workflow/lol.csv" Such file would be located inside the workflow, but i…

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

simple date string conversions

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…

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

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…

string to date M/d/yyyy vs. MM/dd/yyyy

Match similar addresses from one list together into similar groups

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

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 missings in string replace(column("Column1"), " "," ")

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