Investment Studio > Expressions > Functions > Text > REPLACE

string replace(string in_string, integer start, integer length, string replacement_string)

Returns in_string with the length characters in positions start to start + length - 1 replaced with replacement_string.

Example

=replace("1234567890", 4, 3, "four,five,six")

equals "123four,five,six7890": the length = 3 characters starting at position start = 4 ("456") are replaced with the string "four,five,six".

See also clean, find, left, mid, right, search, substitute, trim.