

Regex Extract

RegexExtract extracts and adds one or more new fields to the data by using a regular expression.

Parameters

regex Required

A valid JavaScript regular expression with at least one group. For example: "^Sample(\\d+)$".

Read more at: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions

field Required

The source field

as Required

The new field or an array of fields where the extracted values are written.

skipInvalidInput

Do not complain about invalid input. Just skip it and leave the new fields undefined on the affected datum.

Default: false

Example

Given the following data:

Gene	Genome Location
AKT1	14:104770341-104792643

... and configuration:

{
  "type": "regexExtract",
  "field": "Genome Location",
  "regex": "^(X|Y|\\d+):(\\d+)-(\\d+)$",
  "as": ["Chrom", "Start", "End"]
}

Three new fields are added to the data:

Gene	Genome Location	Chrom	Start	End
AKT1	14:104770341-104792643	14	104770341	104792643