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

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

NameTitleDescription
inputColsInput ColumnsColumns on which to apply Regex
searchPatternsFindEnter Search Pattern
replacePatternsReplaceEnter replacement Value

Examples

Input

nameageheight
StringTypeIntegerTypeStringType
Alice580
Alice580
Alice1080
James550
James1060
James780

Parameters

IdInput ColumnsFindReplace
1nameAl*Jim
2height8060

Output

nameageheight
Jimice560
Jimice560
Jimice1060
James550
James1060
James760