topic Re: Issue getting TRANSLATE statement working.... in Application Development and Automation Discussions

Issue getting TRANSLATE statement working....

Former Member — Wed, 29 Apr 2009 20:07:32 GMT

Hello,

I am having trouble understanding translate statement.

DATA: LETTERS(4) VALUE 'YaaX',

CHANGE(4) VALUE 'aXba'.

TRANSLATE LETTERS USING CHANGE.

WRITE: LETTERS.

The output is 'YXXX'. But I am not sure why this is.

I thought that every letter that exists in another letter gets replaced by the letter that follows it and if does not exit then it remains unchanged. So b does exist after X but still the output shows X at end and not b as below.

So the output should be 'YXXb'.

Please help

Regards,

Jainam.

Edited by: Jainam Shah on Apr 29, 2009 10:08 PM

Re: Issue getting TRANSLATE statement working....

Former Member — Wed, 29 Apr 2009 20:12:44 GMT

In your example it replaces a with X and b with a. TRANSLATE works with groups of two letters.

Rob

Re: Issue getting TRANSLATE statement working....

former_member156446 — Wed, 29 Apr 2009 20:14:07 GMT

Hit an F1 on TRANSLATE and check the documentation.