04-06-2006 1:12 AM
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?
04-06-2006 1:18 AM
The error that I receive is "Unable to interpret "7.77E-10" as a number"
04-06-2006 1:18 AM
The error that I receive is "Unable to interpret "7.77E-10" as a number"
04-06-2006 1:54 AM
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.
04-06-2006 1:53 AM