Expand Barcode

This nodes takes a string column and appends the information content of the barcode string into several new columns (e.g. library code, library plate number, project code, assay, date, replicate).

The node uses a regular expression that tries to match the barcode column. Possible barcode patterns can be set at:
KNIME->Preferences->KNIME->HCS-Tools->Barcode patterns

This is an example:

Selected Barcode Pattern: (line breaks only for better visualization)
(?<libplatenumber>[0-9]{3})
(?<projectcode>[A-z]{2})
(?<date>[0-9]{6})
(?<replicate>[A-z]{1})
-
(?<libcode>[_A-z\d]{3})
(?<assay>[-_+\s\w\d]*)
Extracted metadata columnsBarcodes from input columnlibrary plate numberproject codedatereplicatelibrary codeassay001AL100914C-CPW1nMovn1AL100914CCPW1nMovn006AL100914A-CPW1nMovn6AL100914ACPW1nMovn001MB140502D-KBI_lowGlucose1MB140502DKBI_lowGlucose

Each wanted meta information is marked as a named group and results in a new column.

Definition pattern: (?<groupname> regular expression )

The group name will be the name of the new column, beside a few exceptions: group namecolumn namelibplatenumberlibrary plate numberlibcodelibrary codeprojectcodeproject codeconcunitunit of concentration

Input ports

1. Type: Table
   Plate data
   Table with barcode column

Output ports

1. Type: Table
   Input table with barcode metadata
   Input table with additional columns containing the extracted barcode metadata.