RE: v5r2 %dec using character argument causing RNQ0105

It happens to all of us.  If I only had a nickel for every time I missed
something in the manuals.

Buck's reference might provide a better solution for you.

Rick

-----Original Message-----
From: Dan [mailto:dbcerpg@xxxxxxxxx]
Sent: Tuesday, March 18, 2003 11:36 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: v5r2 %dec using character argument causing RNQ0105

Sheesh.  I really *did* RTFM!  It was right under my nose and I missed it.

<sheepish grin>
Thanks Rick!
- Dan

--- "Chevalier, Rick" <Rick.Chevalier@xxxxxxxxxxxxxxx> wrote:
> Dan,
>
> It's the comma.  The following is taken from the RPG reference manual.
>
> *-----------------------------------------------------------------
> * If the character data is known to contain non-numeric characters
> * such as thousands separators (like 1,234,567) or leading
> * asterisks and currency symbols (like $***1,234,567.89), some
> * preprocessing is necessary to remove these characters from the
> * data.
> *-----------------------------------------------------------------
> D data s 20a inz('$1,234,567.89')
> D num s 21p 9
> /free
> // Use the %XLATE builtin function to replace any currency
> // symbol, asterisks or thousands separators with blanks
> num = %dech(%xlate('$*,' : ' ' : data)
> : 21 : 9);
> // If the currency symbol or thousands separator might
> // vary at runtime, use variables to hold these values.
> num = %dech(%xlate(cursym + '*' + thousandsSep : ' ' : data)
> : 21 : 9);
>
> Rick


__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
_______________________________________________
This is the RPG programming on the AS400 / 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.