Chris Allen <[email protected]> writes:
> I have an ASCII data file with lines in fixed length format. (created
> from a PDF with copy and paste) I want to create a spread sheet from
> it so that I can sort and select by the various columns.
>
> I can not find that option in Open Office. Any Ideas?
I don't know of a fixed length field importer for OOo; my approach would
be to write a ten second Perl hack to handle it using unpack and
Text::CSV; read and split the input rows, spit out CSV, and be done with
it.
Regards,
Daniel
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html