Replace String
Last updated
Last updated
source_col
column
A string column from which to replace a pattern.
pattern
string
This is the regex pattern that you want to match.
replacement
string
This is the value used as a replacement for the pattern.
alias
string
A column name to assign the resulting column.
True
use_regex
boolean
Use regex to find string pattern to replace defaults to 'false'; however, regex will be used if any of 'position', 'occurrence', or 'parameters' are provided, regardless of this value.
True
position
int
Number of characters from the beginning of the string where the function starts searching for matches. Default: 1
True
occurrence
int
Specifies which occurrence of the pattern to replace. If 0 is specified, all occurrences are replaced. Default: 0
True
parameters
string
String of one or more characters that specifies the parameters used for searching for matches. Supported values: c , i , m , e , s. Default: c
True