How can I keep leading zeros when building a CSV file?

Last updated: 07/03/2009

Votes: 6

Comments: 0

Some data looks like a number on the surface, but really is not meant to be used that way. Zip codes are one such data type.

When creating a CSV file, a zip code like 01039 will come up in Excel as 1039, which is not what you want.

An easy fix is to enclode the zip code as follows, when generating your CSV:

..."PA",="01039","blah"...

the = sign seems to tell Excel to keep the literal, and not try cleaning it up.

Other questions in this category:

	What causes an Error 400 when running php on IIS?
	Function to handle string substitution in php
	What causes array problems with php from one host to another?
	My php installation can't write to the Save Session Path - how do I fix it?
	how can I output my php arrays in a readable html format using print_r?
	How can I get mysql table definitions in my php script?
	How can I execute commands on mysql using a php script?
	How can I capture the contents of an included file?
	How can I slash out a price to denote a sale price in html and php?
	php session id keeps changing on every reload - how can I fix this?
	How can I get php errors to show in the browser?
	When I try adding text to images in php, the color does not match what I want. How can I fix this?
	How can I get bounced emails from my email CGI or PHP script?
	How can I modify a script that relies on register globals being turned on?
	Configuring htmleditor to do file uploads using php
	How can I format my php print_r statements to be more readable in html?
	How can I make a state drop down list for my forms?
	Why doesn't ftp_connect work in my php script?
	How can I force my php scripts to run php5 ?
	Why isn't my ioncube installation not working?
	How can I remove strange characters from a string in php?
	How can I test a portion of my php code without everyone seeing it?
	How can I turn off the + / - that shows up in my oscommerce product listing?
	How can I authenticate a user in my vbulletin database from a php script?
	My php scripts aren't registering $HTTP_GET_VARS variables anymore!
	How do I get rid of "Fatal error: Allowed memory size of 8388608 bytes exhausted" in my php scripts?
	Resizing images in php doesn't work
	I need a php function to put all rows from a mysql query into an array

Content provided by Roberts WebForge, Inc.

Technology TidBits

How can I keep leading zeros when building a CSV file?