English QlikView 12.10

Replace - script and chart function

Replace() returns a string after replacing all occurrences of a given substring within the input string with another substring. The function is non-recursive and works from left to right.

Syntax:  

Replace(text, from_str, to_str)

Return data type: string

Arguments:  

Argument Description
text The original string.
from_str A string which may occur one or more times within the input string text.
to_str The string that will replace all occurrences of from_str within the string text.