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



Any more problematic than some of the other suggested solutions? Seems nobody asked what the origin of the "char field" was, so each resolution simply made an assumption for whatever was left unstated. Given the data in the "char field" was originally storage for a DDS defined 11S04 [AKA S(11,4)], then the overlay is probably the best solution.? The value '0000063900}' being evaluated as negative 63.9 might function better with an overlay than with %dec()?

Regards, Chuck

On 3/24/11 8:14 AM, Vern Hamberg wrote:
This solution would be problematic with negative numbers, by the way.

On 3/24/2011 10:04 AM, paultherrien wrote:
One way would be to use a data structure:

Thedata DS
Char 11 a
Zone 11 s 0 4 overlay(char)

Or :

New_value = %dec(char : 11 : 4) / 10000

Jeff Young on Thursday, March 24, 2011 10:30 AM wrote:

Given an 11 char field with the value of '00000639000', I am
attempting to use %Dec to convert it to an 11.4 position numeric
field.
new_value = %dec(char : 11 : 4).
I *want* the result to be 63.9000, but am getting 639000.0000 as
my result.
What am I not understanding about how this works, and what would
be the best way to get the desired result.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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 [javascript protected email address].

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