[geeks] Microsoft Excel
    Sridhar Ayengar 
    ploopster at gmail.com
       
    Fri Aug 10 13:34:46 CDT 2007
    
    
  
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.  I can't seem to even figure out how to get an 
fs character into the clipboard so that I can try pasting it in the 
dialog box.
I'd like to avoid having to run a tr command before every time someone 
wants to open the file in Excel.  Any ideas?
Peace...  Sridhar
    
    
More information about the geeks
mailing list