My Oracle Support Banner

E-FLO: Leading Zeros in Character fields are Missing in Exported CSV File When Viewing on Excel (Doc ID 1171154.1)

Last updated on DECEMBER 10, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.49 and later
Information in this document applies to any platform.
***Checked for relevance on 20-Sep-2012***
***Checked for relevance on 16-MAY-2014***

Purpose

When exporting data via the file layout with the file layout file type set to CSV, the leading zeroes of character fields are stripped. For example, EMPLID is a character fields and the values are similar to:
00001
00002
etc.

An AE program is created to export the data to a file with a file extension of CSV. Once the AE program completes, the file is opened with Excel. Excel will display the EMPLID column with the leading zeroes missing from the values. Given the above values, in Excel the EMPLID column would have the values of:
1
2
etc.

Why are the leading zeroes removed from character fields?

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.