Re: Re: Exporting from flatfile database

KISS ++ jlongino. The simplest way is almost always the best. You don't need a nuclear warhead like Perl to crack an itty bitty chestnut like this....but of course once you learn Perl you can never go back to simple Excel macros without wishing for....

cheers

tachyon

s&&rsenoyhcatreve&&&s&n.+t&"$'$`$\"$\&"&ee&&y&srve&&d&&print

Comment on Re: Re: Exporting from flatfile database

Replies are listed 'Best First'.
Re: Re: Re: Exporting from flatfile database by grep (Monsignor) on Dec 25, 2001 at 00:16 UTC
I hate to give a non-Perl answer but, keeping with KISS there is a simpler way. Any version of Excel 97 or above (maybe lower, but I cannot verify) will import a pipe delimited file, or any single char delimited file. The import wizard will allow about anything as the delimiter. Just go to Excel, open a copy of the file (preferrablly after changing the extension to .txt). Excel will open up the import wizard. In the first screen select "Delimited" On the next screen select "Other" and put a "\|" in the box. Click through to the end Enjoy a frosty beverage of your choice grep grep> cd pub grep> more beer	[reply]
Re: Re: Re: Exporting from flatfile database by jlongino (Parson) on Dec 24, 2001 at 23:31 UTC
I suppose that instead of an Excel macro she/he could use `Win32::OLE` or somesuch. ;) --Jim	[reply] [d/l]