Re: Sunday Moment ...

Sorry I have to disagree with you on this.

When

My input = 1234

My FromFormat = ABCD

My ToFormat = AB-C=D

then

output = %xlate(FromFormat:ToFormat:input) will be 12-3=4

Try it. I used this technique (learned from Ted Holt) to reformat dates.

Regards,

Carel Teijgeler



Op 24-5-2016 om 18:35 schreef Jon Paris:

Not really Carel - it only does a 1 for 1 replacement.

So turning this: “123456” into “123-456” would not be doable.

%ScanRpl is closer but still is in replacement mode whereas I really want to insert.

Looks like Steve’s subproc is the best starting point.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On May 24, 2016, at 7:24 AM, Carel <coteijgeler@xxxxxxxxx> wrote:

I think XLATE/%xlate can be usefull here.


Regards,

Carel Teijgeler


Op 24-5-2016 om 0:26 schreef Jon Paris:

I know it is Monday but in theory it is a holiday here …

I need to edit some character fields - simply edits similar to what would be needed for a date.

My brain tells me there are functions to do this but edit words and codes only apply to numerics and even among the MI functions they are all numeric.

Am I mismembering? or do I really have to do it the hard way? Seems such a trivial requirement which is why I’m convinced I’m missing something.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

--
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.