Question
Cognizant
IN
Last activity: 20 Nov 2019 9:23 EST
Zeroes getting removed from CSV file while importing
I have a requirement to import an excel file having values from client to a data table in Pega.I converted the excel file CSV format but the issue is that before conversion if a value is 012345 but when after converting it to CSV its being changed to 12345.I need that 012345 for my logic purpose.
Kindly help me with a solution for importing the correct file in correct format.
Pegasystems Inc.
IN
Perform the following actions to maintain leading zeros:
- Export data to a CSV file.
- Open Excel.
- Select Create a new spreadsheet.
- Click on the DATA tab.
- Double click on From Text.
- Navigate to the folder containing the CSV file.
- Follow the prompts selecting Delimited.
- Select Comma delimiters.
- For data format, select TEXT for each column for which you want to maintain lead zeros.
- Click Finish and OK to import data.
Cognizant
IN
I have followed the same steps but the final output excel is in xlsx format only not in CSV if i convert it to CSV again 0 are getting removed again.
Pegasystems Inc.
IN
Hi,
From the description, I could see the below link is similar to the issue you are referring to.
https://collaborate.pega.com/question/csv-file-containing-leading-zeros
Hope this helps!
Thanks,
Geeda.