next up previous contents index
Next: RIGHT Up: A Function Reference Previous: REPEAT

REPLACE

 

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''


next up previous contents index
Next: RIGHT Up: A Function Reference Previous: REPEAT

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999