Hi there,

I try to TRANSFORM 'ABCDEFG' into 'ABC-DEFG' by issuing TRANSFORM('ABCDEFG','XXX-XXXX'), but the outcome given by TRANSFORM is 'ABC-EFG'), noted that the 'D' had been replaced with '-'. Am I missing something here? Please help.

TIA,
juan