How to import csv without removing zero

How to import csv without removing zero

hashsalacophashsalacop Posts: 19Questions: 5Answers: 0

Example :

data -> 06516

improt to csv result -> 6516

Answers

  • kthorngrenkthorngren Posts: 21,166Questions: 26Answers: 4,921

    Exporting to a CSV with leading zeros works here:
    http://live.datatables.net/secihidi/1/edit

    Here is the table:

              <tr>
                <td>Tiger Nixon</td>
                <td>01234</td>
              </tr>
              <tr>
                <td>Garrett Winters</td>
                <td>5768</td>
              </tr>
    

    Here is the resulting file:

    "Name","Value"
    "Garrett Winters","5768"
    "Tiger Nixon","01234"
    

    Are you opening the CSV in a text editor or Excel?

    Please update my test case to replicate your issue.

    Kevin

  • hashsalacophashsalacop Posts: 19Questions: 5Answers: 0

    I tried the two text editor and csv. but does not work.

  • hashsalacophashsalacop Posts: 19Questions: 5Answers: 0

    Thank you sir kthorngrenkthorngren it worked..

This discussion has been closed.