×
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.
Nothing is wrong. Your desired result is a 5 character field with
leading zero, the data you are moving is a 5 character field with
trailing blank.
I am assuming the 5A field has 1000 not 1000. that is no decimal point.
Looks like you want to do a trim of the blank with right adjust and zero
fill. EVAL wont do that.
Perhaps a EVALR with %trim but even so the result will have a leading
blank. Then do a %ScanRpl to replace the blanks with zeros.
Maybe the real issue is transferring numeric data from EXCEL into an
alpha field, but that is a just a guess.
Frank
On 01/04/2021 7:46 pm, Dave wrote:
What's gone wrong!?
A PF has been populated from copying a spreadsheet from EXCEL and it
now has a 5A field with the value 1000.
The program using this file simply moves this to another file with an EVAL
operation. But the desired result is '01000' and not '1000 '
How can I avoid MOVE *ALL '0' followed by MOVE?!
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.
midrange.com
