[Novalug] Spreadsheet Problem

[Dave Aronson]

On Thu, Apr 8, 2010 at 19:14, Dan Arico <dan_arico at aricosystems.com> wrote:

> Somebody sent me a mailing list as a csv file. It opens just fine, either as a
> spreadsheet or a text file. My problem stems from the fact that zip codes are
> not being treated consistently. A nine digit zip with a hyphen in it is
> treated as a string. A five digit zip is treated as a number. I need a way to
> force it to be treated as a string.

Just a wild guess -- see if you can whip up a vi macro to insert a
single-quote at the start of each one.  That will also help the ones
that start with a zero, be treated properly (so it won't think 00123
== 123).

-Dave

-- 
Dave Aronson - Have Pun, Will Babble | Work: davearonson.com | /\ ASCII
-------------------------------------+ Play: davearonson.net | \/ Ribbon
"Specialization is for insects."     | Life: dare2xl.com     | /\ Campaign
-Robert A. Heinlein                  | Wife: nasjleti.net    | Email<>Web