Regex Substring

Returns match(es) of a substring as a new string column
Multiple return modes cn be selected (first match, last match, match by number or concat all matches)

Options

Regex column
Column you want to apply the regex to
Regex String
Regex you want to apply
Return Mode
Define which match should be returned -first match = returns first match in string -last match = returns last match in string -match by number = returns match by defined number -concat all matches = returns all matches - concatenated by delimiter character
Concat delimiter
Define your delimiter character here when "concat all matches" mode is selected
Match number
Define which match you want to be returned when "match by number" mode is selected Returns empty string if number of matches are less than selected number

Input Ports

Icon
Table with input data

Output Ports

Icon
Table with regex collection column

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.