E-FLO: Leading Zeros in Character fields are Missing in Exported CSV File When Viewing on Excel
(Doc ID 1171154.1)
Last updated on APRIL 04, 2025
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.49 and laterInformation in this document applies to any platform.
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 |