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