Re: Sunday Moment ... -- RPG400-L

Side note, I just saw this technique for the first time a few days ago.

However, in that case, the person was trying to use it in SQL...

select translate('ABCD-EF-GH IJ:KL:MN', '20160101123059','ABCDEFGHIJKLMN')
from sysibm.sysdummy1

Works quite nicely. However, the user was trying to do

select translate('ABCD-EF-GH IJ:KL:MN', mycolumn,'ABCDEFGHIJKLMN')
from mytable

And that was failing as SQL's translate() function requires a string
constant for parameter #2.

If I wanted to use it in RPGLE, I'd stick it in it's own procedure.

Charles

On Tue, May 24, 2016 at 4:27 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

Yep - just spotted that and been playing with it Brian. Apologies to Carel
for ever doubting … but good grief.

It is not often I disagree with Ted but for me this is a complete and
absolute no-no in the same vein as Multiply by 10000.01 and similar nasty
tricks.

I’ve been using RPG IV since before it existed and (as I said earlier)
even went back to the manual to be sure I had understood it correctly. What
I failed to notice until I went into Ted’s example was that it was being
used in what I can only describe as a perverted manner.

I like to learn new things - this is certainly new. And now that I know it
I’m going to attempt to bury it in the deepest darkest recesses of my brain
lest I should ever be tempted to use it!

Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On May 24, 2016, at 4:17 PM, Brian May <bmay@xxxxxxxxxxxxxxxxx> wrote:

Jon,

Notice the order of the parameters.

%xlate()'s parameters are
1. characters to replace
2. replacement charaters
3. string to be translated

In the example, the variables are named by their intention, not

necessarily how %xlate uses them.

The "ToFormat" field is actually the string to be translated. The Input

String is the replacement characters. The From format is the characters to
be replaced.

So '(ABC) DEF-GHIJ' is the string being processed. The letters are

being replace with the corresponding numbers.

:)

Brian May
Solutions Architect
Profound Logic Software
http://www.profoundlogic.com
937-439-7925 Phone
877-224-7768 Toll Free

The IBM i Modernization Experts
www.profoundlogic.com

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon

Paris

Sent: Tuesday, May 24, 2016 3:12 PM
To: Rpg400 Rpg400-L <rpg400-l@xxxxxxxxxxxx>
Subject: Re: Sunday Moment ...

Did you actually run this Dave? I’ve looked at the original article as

per Chuck’s post and I can’t see how it ever worked.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On May 24, 2016, at 3:42 PM, dlclark@xxxxxxxxxxxxxxxx wrote:

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 05/24/2016
03:33:06
PM:

Try the following revision to the above:

Result =
'Result is: ' + %xlate(FromFormat: InputString: ToFormat);

FWiW, the reference\allusion made to /the technique/ to rearrange
the

digits and add separators [from the mask], to which no link was

provided:

[http://www.itjungle.com/fhg/fhg030106-story02.html]
Omit Commas from Numeric Dates
Published: March 1, 2006 by Ted Holt

That is soooo cool! Love it.

dcl-c FromFormat 'ABCDEFGHIJ';
dcl-c ToFormat '(ABC) DEF-GHIJ';
dcl-c InputString '1234567890';
dcl-s ResultString varchar(50);

ResultString = 'Result is: ' + %xlate(FromFormat: InputString:
ToFormat);

DSPLY ResultString '*EXT';

*inlr = *on;
return;

Sincerely,

Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300

Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331

**********************************************************************
*********************** This email message and any attachments is for
use only by the named
addressee(s) and may contain confidential, privileged and/or
proprietary information. If you have received this message in error,
please immediately notify the sender and delete and destroy the
message and all copies. All unauthorized direct or indirect use or
disclosure of this message is strictly prohibited. No right to
confidentiality or privilege is waived or lost by any error in

transmission.

**********************************************************************
***********************
--
This is the RPG programming on the IBM i (AS/400 and iSeries)
(RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)

mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,

visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at

http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)

mailing list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.