Syntax: @REPLACE(S1, N1, N2, S2)
S1 = a string value
N1 = a numeric value
N2 = a numeric value
S2 = a string value
@REPLACE returns the string formed by replacing the N2 characters starting at position N1 in string S1 with string S2.
Examples:
@REPLACE(``John'', 1, 3, ``ack'') = ``Jack''
@REPLACE(E1, 8, 3, ``Log'') = ``Expense Logort'', where E1 = ``Expense Report''
@REPLACE(E1, 8, 6, ``Log'') = ``Expense Log'', where E1 = ``Expense Report''
@REPLACE(``ABC'', 0, 0, ``XYZ'') = ``XYZABC''