Rule Engine MATCHES - use captured regex value as replacement

[tims]

I have a column from legacy data with different date formats. I am using Rule Engine and specifying one rule for each pattern detected and converting entire column to a standard format.

Can the RHS have access to captured groups? e.g. $0 ?

$datev$ MATCHES “([0-9]+)-/-/” => $0/$1/$3

[izaychik63]

For this purpose you can use

Column Expressions

node.
The captured group will not work also but you can use original column to extract it.

[victor_palacios]

For column expression Column Expressions – KNIME Hub, you can specify the element by subsetting [0], [1], etc.

column(“column1”).match(/([0-9]{5})/)[0]

But Regex Find All is also nice:

Regex Find All – natanaeldgsantos