[geeks] Microsoft Excel

Jonathan C. Patschke jp at celestrion.net
Fri Aug 10 15:34:17 CDT 2007


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



More information about the geeks mailing list