Exponent
Moderators: chulett, rschirm, roy
Exponent
Hi,
I have a file which has some data as 1234E567. When I output it as a .csv file it is displayed as 1234E+112. Somehow the character "E" is read as a formula in excel. What I need is 1234E567. I tried putting the string in double quotes but again the data is displayed as 1234E567". If I put the string in single quote it is displayed as '1234E567. How can this be resolved?
Thanks.
I have a file which has some data as 1234E567. When I output it as a .csv file it is displayed as 1234E+112. Somehow the character "E" is read as a formula in excel. What I need is 1234E567. I tried putting the string in double quotes but again the data is displayed as 1234E567". If I put the string in single quote it is displayed as '1234E567. How can this be resolved?
Thanks.
Seems to be a known Excel "issue" when you do an automatic import by, say, double-clicking on a .csv file. Doesn't seem to be a good, automated solution other there, found this as one possibility:
http://www.pcreview.co.uk/forums/thread-1049984.php
Otherwise, it seems like you'd need to create a .txt file rather than a .csv to force the process through the Text Import Wizard. Teach your customers to change this column from 'General' to 'Text' during the import and it will import correctly.
If you want to explore, perhaps try what I did - Google for a phrase like "excel import csv with exponent". Not really a DataStage problem but if you can find a solution that involves how the file is create it, you should be able to handle it via DataStage. Otherwise, you are in Microsoft's hands.![Sad :(](./images/smilies/icon_sad.gif)
http://www.pcreview.co.uk/forums/thread-1049984.php
Otherwise, it seems like you'd need to create a .txt file rather than a .csv to force the process through the Text Import Wizard. Teach your customers to change this column from 'General' to 'Text' during the import and it will import correctly.
If you want to explore, perhaps try what I did - Google for a phrase like "excel import csv with exponent". Not really a DataStage problem but if you can find a solution that involves how the file is create it, you should be able to handle it via DataStage. Otherwise, you are in Microsoft's hands.
![Sad :(](./images/smilies/icon_sad.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Huh, it actually worked for me when I tested it. As long as you didn't mind the 'extra' character in the field, that is. [shrug]
The conversion mentioned was manual, as noted there doesn't seem to be any automated solution out there. Or did you want to convert it from scientific notation to... not scientific notation?
The conversion mentioned was manual, as noted there doesn't seem to be any automated solution out there. Or did you want to convert it from scientific notation to... not scientific notation?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers