[geeks] Microsoft Excel

[Lionel Peterson]

"tr" is your friend, you could make the unprintable character into something acceptable to Excel...

Lionel

>From: "Jonathan C. Patschke" <jp at celestrion.net>
>Date: 2007/08/10 Fri PM 03:34:17 CDT
>To: The Geeks List <geeks at sunhelp.org>
>Subject: Re: [geeks] Microsoft Excel

>On Fri, 10 Aug 2007, Sridhar Ayengar wrote:
>
>> For various reasons, I need to use a non-printable character as a
>> delimiter in a text file.  I thought ASCII fs (0x1c) would probably be
>> a good choice.  It works fine in my scripts and it's easy to generate
>> in Servlets.
>>
>> The problem is that I can't convince fucking Microsoft Excel to import
>> files delimited with fs.
>
>Have you considered generating a file with fixed-width columns instead
>of a delimiter?  Excel can usually swallow those pretty well.
>
>-- 
>Jonathan Patschke     ) 
>Elgin, TX            (      "I detest logging filesystems."
>USA                   )                    --Linus Torvalds
>_______________________________________________
>GEEKS:  http://www.sunhelp.org/mailman/listinfo/geeks