Skip to main content
info
This documentation is for version v2.3 of the product.
For the latest version(v2.7) documentation click here
Version: v2.3 print this page

MultiRegexExtractor

This node to extract pattern from input columns

Input

This type of node takes in a DataFrame and transforms it to another DataFrame

Output

This node extract pattern from input columns as specified

Type

transform

Fields

NameTitleDescription
inputColNamesInputColumnsNameColumns
outputColNamesOuputColumnsNamename of the output column
patternsPatternspatterns or regex to extract the input column name
groupsGroupsAn regular expression group number starting with 1, defining which portion of the matching string will be returned

Examples

Input

idnamedatetime
StringTypeStringTypeStringType
1Robert ryl2018-10-11 12:10:22
2Daniell Hammack2017-10-11 10:10:22
3Versie Hillebrand2013-10-11 20:10:22
4Markita Hansen2012-11-13 23:10:25
5Kary Hendrixson2017-10-18 22:10:26

Parameters

InputColumnsNameOuputColumnsNamePatternsGroups
name(.) (.)firstname1
name(.) (.)lastname2
datetime([0-9]4-[0-9]2-[0-9]2)date1

Output

idnamedatetimefirstnamelastnamedate
StringTypeStringTypeStringTypeStringTypeStringTypeStringType
1Robert ryl2018-10-11 12:10:22Robertryl2018-10-11
2Daniell Hammack2017-10-11 10:10:22DaniellHammack2017-10-11
3Versie Hillebrand2013-10-11 20:10:22VersieHillebrand2013-10-11
4Markita Hansen2012-11-13 23:10:25MarkitaHansen2012-11-13
5Kary Hendrixson2017-10-18 22:10:26KaryHendrixson2017-10-18