topic Re: Exponential number in Application Development and Automation Discussions

Exponential number

Former Member — Thu, 06 Apr 2006 00:12:46 GMT

Hi,

I have a .txt file that I'm uploading to a Z table.

In the .txt file I have some numbers like 7.77E-10 that are giving me problems when I try to assign it to a field of type DEC.

Anyone have an idea of what do I need to do to solve this problem?

Former Member — Thu, 06 Apr 2006 00:18:17 GMT

The error that I receive is "Unable to interpret "7.77E-10" as a number"

RichHeilman — Thu, 06 Apr 2006 00:53:27 GMT

Try to assign to a type F field.

Regards,

Rich Heilman

former_member186741 — Thu, 06 Apr 2006 00:54:03 GMT

what you actually have is a character field that you need to convert to a float...try this:

data f type f.

data c(20) type c value '7.77E-10'.

call function 'CHAR_FLTP_CONVERSION'

exporting string = c

importing flstr = f.