Skip to Content
avatar image
Former Member

Getting issue while Downloading excel with leading zero from GUI_download in DBF format

Hi Folks,

I have to download an excel from GUI_DOWNLOAD with leading zero ,So I have use DBF format but the issue is all the japanese character is now coming as # . I have use code page 8000, this is working fine in ASC format but in that case leading zero is not coming. If anybody work on this type of requirement kindly help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 20, 2018 at 05:03 PM

    "Leading zero not coming" - do you just not see the leading zero when you open the file in Excel? When there are only numeric characters in a cell Excel automatically converts it into a number format and drops the leading zeroes. This is a known effect and questions about it have been answered many times. Use Google.

    Otherwise provide more details on what the issue is exactly and what have you done so far to troubleshoot this.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2018 at 06:39 PM

    I have no experience with dbf containing Japanese characters, but several years ago I had to deal with dbf with Armenian texts.

    Do not use Excel to view these, on top of somewhat misleading numbers representation, the display and texts can be messed up too - even when the file is correct!

    If memory serves, for most of the time I used LibreOffice to view the generated files, because there was an option to select the desired code page when you open the file.

    Another set of tools that I used before installing LibreOffice was a combination of Notepad++ and a small utility (via command prompt) that displayed information for header and field descriptor sections.

    Edit: the reason why I mentioned these tools is to hint that before jumping to a conclusion that there is a problem with your code you could verify the file correctness with alternative software.

    Add comment
    10|10000 characters needed characters exceeded