Version: v2.5
FindAndReplaceUsingRegexMultiple
This node finds and replaces text in a column containing string
Input
It accepts a DataFrame as input from the previous Node
Type
transform
Fields
Name | Title | Description |
---|---|---|
inputCols | Input Columns | Columns on which to apply Regex |
searchPatterns | Find | Enter Search Pattern |
replacePatterns | Replace | Enter replacement Value |
Examples
Input
name | age | height |
---|---|---|
StringType | IntegerType | StringType |
Alice | 5 | 80 |
Alice | 5 | 80 |
Alice | 10 | 80 |
James | 5 | 50 |
James | 10 | 60 |
James | 7 | 80 |
Parameters
Id | Input Columns | Find | Replace |
---|---|---|---|
1 | name | Al* | Jim |
2 | height | 80 | 60 |
Output
name | age | height |
---|---|---|
Jimice | 5 | 60 |
Jimice | 5 | 60 |
Jimice | 10 | 60 |
James | 5 | 50 |
James | 10 | 60 |
James | 7 | 60 |