Version: v2.3
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
Name | Title | Description |
---|---|---|
inputColNames | InputColumnsName | Columns |
outputColNames | OuputColumnsName | name of the output column |
patterns | Patterns | patterns or regex to extract the input column name |
groups | Groups | An regular expression group number starting with 1, defining which portion of the matching string will be returned |
Examples
Input
id | name | datetime |
---|---|---|
StringType | StringType | StringType |
1 | Robert ryl | 2018-10-11 12:10:22 |
2 | Daniell Hammack | 2017-10-11 10:10:22 |
3 | Versie Hillebrand | 2013-10-11 20:10:22 |
4 | Markita Hansen | 2012-11-13 23:10:25 |
5 | Kary Hendrixson | 2017-10-18 22:10:26 |
Parameters
InputColumnsName | OuputColumnsName | Patterns | Groups |
---|---|---|---|
name | (.) (.) | firstname | 1 |
name | (.) (.) | lastname | 2 |
datetime | ([0-9]4-[0-9]2-[0-9]2) | date | 1 |
Output
id | name | datetime | firstname | lastname | date |
---|---|---|---|---|---|
StringType | StringType | StringType | StringType | StringType | StringType |
1 | Robert ryl | 2018-10-11 12:10:22 | Robert | ryl | 2018-10-11 |
2 | Daniell Hammack | 2017-10-11 10:10:22 | Daniell | Hammack | 2017-10-11 |
3 | Versie Hillebrand | 2013-10-11 20:10:22 | Versie | Hillebrand | 2013-10-11 |
4 | Markita Hansen | 2012-11-13 23:10:25 | Markita | Hansen | 2012-11-13 |
5 | Kary Hendrixson | 2017-10-18 22:10:26 | Kary | Hendrixson | 2017-10-18 |