Am 14.09.2012 12:25, Richard Quadling wrote:
Hello. I'm new to using a Mac and some of the things I can do in Windows I'm unable to even work out the question for on a Mac, so please bear with me. The files are generated from an automated system, several hundred a day and have a .tsv extension (can't change it for every file). The files are UTF-8 encoded text files with TAB separated content. I need to be able to double click the file and have it open in Libre Office Calc. Even if it has to ask me to choose the delimiter to process it with.
You can have it much easier. Collect them all in one directory. File>New>Database [X] Connect to existing database Type: Text Specify the directory of the collection, the .tsv suffix, the delimiter etc. [X] Register the database.Save the database file. It is just a configuration file without data. The data are only in your file collection.
Usage: In Writer or Calc hit F4 and drag into your document what you need.Dragging a table icon from the left pane into Calc creates an import range linked to the file. The data view on the right pane can easily be filtered and sorted. YOu can drag (copy) selected rows into a spreadsheet. In Writer you can also drag column headers into the document which generates mail merge fields (place holders for one field value per print out).
-- For 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