On Mon, Mar 9, 2009 at 9:45 PM, Chris Allen <[email protected]> wrote: > 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?
You could rename the extension of file to .csv and then open with Spreadsheet/Calc. It should give you options of how to open the file - you can then choose Fixed Width option. Cheers, Craig A -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
