Announcements
No record found.
Hi Experts,
I am using Text file with file extension as .CSV to export payment file in CSV format in which I need to show the date value format as ddMMyyyy. But, when I check the output CSV file it trims leading zero. (i.e) If the date value is 03092020, it is showing as 3092020 in CSV file. Are there any formulas or am I missing anything please help on this.
Output CSV file:
Can you open the CSV in Notepad ? Excel converts strings to number and removed leading zeros in values.
Check the file with notepad, most likely there's nothing wrong with the exported data, instead it's the Excel cell formatting.
Hello Tarique,
Can you please check your excel template that was used for this electronic report.
In the template you can format the cells as you like.
I wonder if the cell is formatted as an Excel text cell and then attached/linked to your electronic report configuration whether this fixes the issue.
I would expect that but have not tested that.
I leave that to you ;-)
Best regards,
Ludwig
Yes Nuno & Nikolaos.
I can the see the expected output when I open the csv file from Notepad. But, after setting screen as ER destination system is using Excel to open the csv file and also it stores the file with excel format in ER reporting jobs. If I upload payment file to Bank SFTP folder as the destination, I wonder How Bank will open the file to process. Do you have any idea?
Banks obviously process the files automatically, and can definetely handle leading zeros in fields where they are supported.
Hello Ludwig,
I have not used excel template in my reporting. If this is a right way to export payment file in csv format, Kindly provide material links.
Hi Tarique,
If the column is a fixed eight digit number in Excel, then you could try to set the cell format.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 445 Most Valuable Professional
André Arnaud de Cal... 309 Super User 2026 Season 2
CU29091230-0 192
