Export a Text Field with Leading Zeroes to Excel
When you author an Impromptu report, save it as a comma delimited ASCII file (.csv) and open it in Excel, leading zeroes in text columns are dropped. For example, a zip code such as 01803 is truncated to 1803. When you author reports, you can select an option that retains leading zeroes in text fields on export. By default, leading zeroes are not retained.
You can save reports that retain leading zeroes in .csv file format from Impromptu or Impromptu Web Reports. To generate the CSV output in Impromptu Web Reports, you must first author the reports in Impromptu and then publish them to Impromptu Web Reports.
Syntax that allows you to retain leading zeroes on export to Excel is now available in automated reports. For information about this syntax, see Impromptu Macro Help.
Steps
In Impromptu, open a report that uses text values with leading zeroes.
From the Report menu, click General, and in the Report Properties dialog box, select the option Mark text fields for import into Microsoft Excel. Click OK.
From the File menu, click Save As, and specify a name and location for the report.
In the Save as type box, click Delimited ASCII (*.CSV), and click Save.
After saving the file, to view the changes to the file format, open the file in a text editor. Note that an equal sign is inserted now before the opening quotation marks of strings. For example, you find ="00010", ="Sales" instead of "00010", "Sales".
Browse to the location of the .csv file you created and open it with Excel.
Note that in the Excel spreadsheet the leading zeroes appear in the text column.
