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



If you can use free format, the %dec built-in function will handle the blanks for you. This should work regardless of where the '1' is positioned in field ABC.

xyz=%dec(ABC:1:0);




derek gonsalves wrote:

Hi,

I have to move a value from a 10 character field to a 2 decimal

ABC 10
xyz 2 0

I am doing a MOVEL operation to move this value to the numeric field.
Now if i have the value of ABC = 1, then the value passed on to XYZ is 10(Since it moves 1 from left, and initial value of XYZ is 00)
What is the edit code that i can use to remove the trailing Zeros before i move the character field to the numeric field.?

Thanks in advance

Derek

_________________________________________________________________
More photos, more messages, more storage—get 2GB with Windows Live Hotmail. http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_2G_0507


As an Amazon Associate we earn from qualifying purchases.

This thread ...


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 copyright@midrange.com.

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