Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Leading Zeros in Excel file

Former Member

‎12-19-2011 1:38 PM

0 Kudos

Hello,

I am downloading few fields from HR infotypes into Excel sheet, I'm using cl_ABAP_char_utilities=>Horizontal_tab to separate the fields. I'm not getting leading zeros. I have tried with 'DAT', 'CSV' and 'WK1' file formats instead of 'ASC', but the flat file format is changing. I have tried ' ' ' symbol. I am getting leading zeros along with that symbol. Now, I need to remove the symbol. Any suggetions...

Thanks and regards,

PNM Raju

Moderator Message: Duplicate post. Thread locked.

Edited by: Suhas Saha on Dec 19, 2011 7:49 PM

1 REPLY 1

Former Member

‎12-19-2011 1:47 PM

0 Kudos

Hi

Use DBF format

Regards,

Raghu.