Thursday, August 18, 2011

Leading zero drop from CSV file - A solution

In JD Edwards Report we have this issue Leading zero drop from CSV file , you can get output without dropping leading zeros like following:-
 
Open Excel File=> Click on Data=>Double click on From Text =>Select text file SCIInvoice.csv=> click on Delimited=> Click Next=>Select Comma=>click on last column with leading zeros=>Select Text=> Click on Finish =>OK


 

No comments: