How to: |
The OVRLAY function overlays a base character string with a substring.
To use this function, you must import the function library MNTUWS. For information on importing this library, see Accessing and Calling a Function.
There is also an OVRLAY function available for the reporting language. For information on this function, see Character Functions.
OVRLAY(string1, string2, position)
where:
Alphanumeric
Is the base character string.
Alphanumeric
Is the substring that will overlay string1.
Integer
Is the position in the base string at which the overlay begins.
OVRLAY replaces the letters MCA in the MOVIECODE field with MHD:
MAINTAIN FILE movies Module Import (mntuws); Case Top Infer moviecode into MCASTK Compute MCASTK.NEWCODE/A6; For all next Moviecode into stk1 Stack copy from stk1 into MCASTK where moviecode contains 'MCA'; Compute i/i2=1; Type "Original Code New Code" repeat mcastk.Foccount Compute MCASTK(i).Newcode = OVRLAY(MCASTK(I).MOVIECODE, 'MHD', 4); Type " <<MCASTK(i).moviecode <<MCASTK(I).NEWCODE" Compute i=i+1; endrepeat EndCase END
The following are sample values for MOVIECODE and the values for the result of the OVRLAY function:
Original Code New Code 001MCA 001MHD 081MCA 081MHD 082MCA 082MHD 161MCA 161MHD 196MCA 196MHD 530MCA 530MHD 550MCA 550MHD 883MCA 883MHD