IMR export to ASCII (CSV) truncate "0"...

[lstephane]

Hi,

I need to export an Impromptu report to ASCCI (CSV) but need to have number fields pad with "0"...

When exported, the CSV file have "0" truncated".

Any clue how can I keep zeros with CSV exports ?

Thanks !


Stéphane Lambert, Analyst/Programmer - BI Specialist
Info Quest (IQ), Data Warehouse System
McKesson Canada Corporation

EMail: stephane.lambert@mckesson.ca

 

[drlex]

Stephane,
If you open the saved .csv file in "notepad", are the leading zeroes present? I found that if an impromptu report that uses the "number-to-string padded" function is saved as a .csv file, the padding is retained. But if it is opened in Excel, it (Excel) treats the field as a number; stripping the leading zeroes off and displaying it as a numeral.
lex

"Time flies like an arrow, but fruit flies like a banana."

 

[lstephane]

OK... thanks.... you're right !

Thanks a lot...


Stéphane Lambert, Analyst/Programmer - BI Specialist
Info Quest (IQ), Data Warehouse System
McKesson Canada Corporation

EMail: stephane.lambert@mckesson.ca