EXCEL Column Output = 2.00708E+12

[bltcb]

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

[Mhasan]

try using DFloatToStringNoExp

[bltcb]

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

[ds_developer]

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

[bltcb]

Yeah, I have already taken that approach in EXCEL, but the user doesn't want to have to do that! I figured I could do it in DS and resolve the issue from the start.

Still looking at documentation to try to solve in DS.,.
Thanks,
Barbara

[ds_developer]

You might write it as text (so datastage puts quotes around it). I would expect excel to read it then.
John