On Monday 09 March 2009 21:45:56 Chris Allen 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? > > Chris Allen
kate open file ctl-A ctl-C calc ctl-shift-V or ctl-V (depends on which one works) should bring up the "Text Import" window from which you an select "Fixed width" in the Separator Otions and ... go from there. Sometimes I have found that csv needs this extra (kate) step, its probably to do with .... something Witchcraft, no I'm just too tired to zzzzzzzzzzzz ted -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
