CSV to tab delimited

[After Hours]

You can regex it certainly but why not just open it in Excel and
then save it as text?

Or with NeoOffice if you don't want to pay Microsoft for the tool.
Then save as tab-delim instead.

vail

[Bruce Barrett]

Hi,

I'm not the original poster, but I can tell you that Excel
will quite willingly save something other than what it loaded.

If you load: 00123456
Excel will likely save it as: 123456

Fine for $s, I suppose, but for things like part numbers it is
a disaster.

Bruce



As BBEdit-Talk List wrote...

Subject: Re: CSV to tab delimited
Date: Sun, 30 Mar 2008 08:54:02 -0400

You can regex it certainly but why not just open it in Excel and
then save it as text?

Or with NeoOffice if you don't want to pay Microsoft for the tool.
Then save as tab-delim instead.
vail

--
Bruce Barrett See my website at: http://www.brucebarrett.com
... and... I've just started blogging at: <http://brucebarrett.com/b/>

[Doug McNutt]

Post by Bruce Barrett
I'm not the original poster, but I can tell you that Excel
will quite willingly save something other than what it loaded.
If you load: 00123456
Excel will likely save it as: 123456
Fine for $s, I suppose, but for things like part numbers it is
a disaster.

And 001234560012345600123456 -> 1234560012345600000000. It's all about IEEE floating point.

The solution to that is a filter that replaces strings of digits starting with a 0 with the string preceded by a single quote mark. Excel treats things that start with a quote as TEXT.

There are similar problems with date and time that Excel will convert into days and fractions thereof unless you add a leading quote.

Actually you can add spaces to numbers with the same effect but that can be confusing later.
--
--> From the U S of A, the only socialist country that refuses to admit it. <--