Hello,
I'm new to this forum, hope I'm in the correct place!
Quick question.,.
I am reading an Oracle db, the column is varchar2(13). I have defined the column as VarChar (13) in DS Oracle Enterprise stage. The data contains information like 2007092112345. Going thru a transformer as VarChar (13), ending up in a sequential file as the same datatype. The sequential file is defined as tab delimited. When the file is opened in EXCEL, it shows 2.00708E+12
I have tried to change the datatype in each stage, but still get the same results.
How can I make this be the regular number and show 2007092112345 in EXCEL?
Any help would be greatly appreciated!
Thanks,
Barbara
EXCEL Column Output = 2.00708E+12
Moderators: chulett, rschirm, roy
Thanks, but I can't find any information on how to use this TYPE CONVERSION. In the transformer stage, I see this under type conversion, but the syntax is not very helpful:
DFloatToStringNoExp(%number%,%scale%)
Should I keep the datatype as VARCHAR? Do I need to add a MODIFY stage?
Do you have an example?
Thanks in advance for your help!
Barbara
DFloatToStringNoExp(%number%,%scale%)
Should I keep the datatype as VARCHAR? Do I need to add a MODIFY stage?
Do you have an example?
Thanks in advance for your help!
Barbara
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
It is an Excel issue - highlight the column, right mouse and go to Format Cells... change the type to Number with 0 decimal places and no 1000 separator. It will work with your E+12 data. I know I've done it with E+14, but at E+18 it loses precision (I don't know where the exact cut-off is).
Hope this helps,
John
Hope this helps,
John
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA