× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.