Am 25.07.2011 15:32, Tom Davies wrote:
Hi :) I think i would approach this by using a database program rather than importing into a spreadsheet program. A database program such as Base should be able to read the text-files directly. Queries, Forms and Reports can be set-up to do the required calculations.
Right, a Base makes text import into office documents easy. You can specify the delimiters and everything once for ever and use the resulting database connection in all documents. There are 2 ways. One uses Base for trivial read-only access to a whole directory of csv files. The second method is less trivial and utilizes the built-in HSQLDB (or some other connected database server) to bind one particular text file to one particular database table for full database access.
Example with 5 files demonstrating several use cases with HSQLDB, Base and Calc: http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=23727
-- Unsubscribe instructions: E-mail to users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted