Anonymous
Unregistered
hai,
i am downloading data from mysql database to .csv format.the data is correctly downloading,but if any field starting with zero(0),then zero is missing
eg:phone number:012345778987//which is stored in db.
but in .csv file the phone number is storing like this 12345778987
what is reason thanks to you.
Anonymous
Unregistered
hai spark
actually we are using excel sheet for downloading, but we make a trial to download the data as .csv format.but is there any way to solve that problem
Anonymous
Unregistered
Did you not read the info posted at the link in my previous post? The problem you face doesn't lie in the CSV file, but in the way Excel displays CSV files.
If you want to check however, just open the CSV file in a text editor (like Notepad, not Word)to confirm whether or not the leading zero is included.
Else, you need to follow what's written in that link -
To implement this fix, double quote each field with leading zeros or spaces and place an equals sign (=) directly ahead of the first quote, like this:
="08075"
TIP: Perhaps you could write a macro to ensure that the data in that particular column is formatted as text and not the default numerical value.
Anonymous
Unregistered
Generally text fields in .CSVs are denoted with double quotes (") around them.
But you probably don't want to go through every row in Notepad and add quotes....
So in Excel, in a new column, use a formula to change the format. Let's say your phone numbers are in column A and you have a row of headers. So in some other empty column, type in =Text(A2,"000-00-0000") and drag/fill the formula down for all rows.
But you don't want to store this as a formula, so select that entire column and Copy. Select the column that contains the problem-phone numbers (without leading zeros) and Paste Special > Values. This will convert the formulas to text values. Now delete the formula column.
Also, you can eliminate this entire problem by correctly entering the phone number in the international format:
+<intlcode>-<area code>-<phone number>
like +91-22-12345678
Anonymous
Unregistered
Thank You Spark.
I Implmented your sugession,its working.
Bye
You must log in to post.