Re: [libreoffice-users] How do I open a file with a .tsv extension as a .csv file on a Mac OSX (Lion?) using OpenOffice Calc.

On 14 September 2012 16:33, Jay Lozier <jslozier@gmail.com> wrote:

>  On 09/14/2012 11:21 AM, Richard Quadling wrote:
>
>
>
> On 14 September 2012 16:04, Jay Lozier <jslozier@gmail.com> wrote:
>
> >   On 09/14/2012 09:46 AM, Richard Quadling wrote:
> >
> >
> >
> >  As an experiment, change the extension on one of a copy of a files from
> > > *.tsv to *.csv. From your description, it sounds like *.tsv is a tab
> > > delimited text file and *.csv nominally is comma delimited text file.
> > >
> > > When importing into Calc make sure to highlight Tab as the delimiter not
> > > comma, Calc will remember the last delimiter used.
> > >
> > > If this is successful there are two possible options: change the default
> > > settings of the program that generated the file or determine an "easy"
> > > way to convert the *.tsv files to *.csv files.lo
> >  This is what I already do. It is painful. I work on these file and then
> > they are shared and stored and processed by other systems (not just me).
> > Renaming them excludes them from everything EXCEPT calc.
> >
> >  I think if I can get Calc to run automatically, with the double clicked
> > (or CMD+O for open - just found that today), then I'll be a LOT happier.
> >  --
> > Richard Quadling | richard@fantasyshopper.com |
> > http://www.fantasyshopper.com
> >
> >   Fantasy Shopper <http://www.fantasyshopper.com/>
> > http://www.fantasyshopper.com/
> >
> > Fantasy Shopper: a fun new website where you can fulfill all your
> > shopping fantasies! With more than 300 real shops you can build your
> > Fantasy Wardrobe with real clothes, style outfits for you and friends and
> > compete with the community for real prizes.
> >
> >   Richard,
> >
> > If you want to try using the command line you might try the following
> > scripts in Terminal:
> > 1)
> >
> > this shell script should do it - note that I use copy instead of move,
> > for test purposes
> >
> > for i in *,tsv
> > do
> > b=basename $i .tsv
> > cp $i ${b}.csv
> > done
> >
> > 2)
> >
> > rename "s/\.tsv$/.csv/" *.tsv
> >
> > \ and/or $ may require escaping in your shell
> >
> > Both are Linux/Unix scripts and the recent Mac OS is a derivative of BSD;
> > a Unix derivative very similar to Linux. I would create a folder of
> > duplicates.
> >
> > A hat tip to the Atlanta Linux Enthusiasts for the scripts.
> >
> > A quick search indicates that *.tsv files are often exported by Quicken.
> > They are a non-standard format; *.csv is easily understood by spreadsheets
> > and databases.
> >
> > --
> > Jay Lozierjslozier@gmail.com
> OK. I've clearly not explained myself. And I know Windows isn't
> Mac/*nix/etc.
>
>  I know I can rename the files back and forth all day long. That is
> EXACTLY what I'm already doing. It is plainly a stupid way to go.
>
>  I know I could type lovely long command lines - but why? I want to just
> double click a file and get it to do what I want. And I can't seem to find
> even the simplest questions.
>
>  If I could find the mechanics that associates a file extension to a
> program, I'd be onto a winner with the 'open -a ...' option.
>
>  'open -a LibreOffice.app --args --calc
> /development/_data_canonical/acczuk.tsv'
>
>  works perfectly from the command line. It does exactly what I want.
>
>  So, how do I make THIS the command that is ran when I double click a
> file?
>
> Not sure the command on a Mac, there should be an option to assign tsv
> files to any program. On Windows/Linux it is normally do with a right click
> and selecting the program to use. There may be an option to set the choice
> as the default program.
>
>
>
>  --
> Richard Quadling | richard@fantasyshopper.com |
> http://www.fantasyshopper.com
>
>   Fantasy Shopper <http://www.fantasyshopper.com/>
> http://www.fantasyshopper.com/
>
> Fantasy Shopper: a fun new website where you can fulfill all your shopping
> fantasies! With more than 300 real shops you can build your Fantasy
> Wardrobe with real clothes, style outfits for you and friends and compete
> with the community for real prizes.
>
>
>
> --
> Jay Lozierjslozier@gmail.com
Non Mac users of LibreOffice are completely missing the fact that
LibreOffice.app is all that the UI shows. Not calc, or whatever the other
modules are called.

And so, I can EASILY associate a tsv file with LibreOffice. No problems
there at all.

But it opens it in the word processor.

I want to associate it with the command line (tested - works)

/System/Library/Frameworks/CoreServices.framework/Framewopen -a
LibreOffice.app --args --calc *****

where ***** is the full path of the file I've double clicked.

This I can do in Windows.

Am I alone in thinking I'm missing a real trick here?

The file arrive on the network automatically, I just want to open one when
I need to, edit it and save it. Other apps deal with the files changing.



-- 
Richard Quadling | richard@fantasyshopper.com |
http://www.fantasyshopper.com

Fantasy Shopper <http://www.fantasyshopper.com/>
http://www.fantasyshopper.com/

Fantasy Shopper: a fun new website where you can fulfill all your shopping
fantasies! With more than 300 real shops you can build your Fantasy
Wardrobe with real clothes, style outfits for you and friends and compete
with the community for real prizes.

-- 
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