Convert numeric to alpha for display
- From: Chipper Miller <chipper.miller@xxxxxxxxx>
- Date: Fri, 31 Aug 2007 06:01:50 -0700
I'm trying to display a 5.0N to a 3A field.
1) First I did this:
Eval(R) alpha3 = %EDITC(numeric5 : 'K');
* Values less than 100 showed up as 3 blanks.
* Values 100 and above showed up as 2 blanks and a "1"
2) Try #2:
Eval(R) alpha3 = %TRIM( %EDITC(numeric5 : 'K');
* Values less than 100 showed up as "digit, digit, 1 blank"
* Values 100 and above showed up as a 3 digit number as desired
3) Try #3:
Eval(R) alpha3 = %TRIMR( %EDITC(numeric5 : 'K');
* Values less than 100 showed up as "digit, digit, 1 blank"
* Values 100 and above showed up as a 3 digit number as desired
4) Try #5:
Eval(R) alpha3 = %TRIML( %EDITC(numeric5 : 'K');
* Values less than 100 showed up as "digit, digit, 1 blank"
* Values 100 and above showed up as a 3 digit number as desired
So far the only other option I can see is to move the values to a 3.0N
and then do option #1.
TIA for any help anyone can give.
.
- Follow-Ups:
- Re: Convert numeric to alpha for display
- From: Dr.UgoGagliardelli
- Re: Convert numeric to alpha for display
- From: Jonathan Bailey
- Re: Convert numeric to alpha for display
- Prev by Date: Re: backup result presentation
- Next by Date: Re: Problem Installing suse 10 on iSeries
- Previous by thread: backup result presentation
- Next by thread: Re: Convert numeric to alpha for display
- Index(es):
Relevant Pages
|
