From: Logan Capaldo <logancapaldo@...>
Date: 2007-02-04T08:18:15+09:00
Subject: Re: Manipulating CSV files over SSH

On Sun, Feb 04, 2007 at 07:47:31AM +0900, Drew Olson wrote:
> All -
> 
> I have a nice little script that takes a large CSV document and splits
> it into 65,000 line chunks which are readable in Excel. However, I
> currently have a .csv file which I'd like to split that is sitting on a
> unix box. I have ssh access to the box, however the file is quite big
> and I'd like to avoid downloading the whole file. Is there a simple way
> to modify my script such that I use the ssh library to access the
> document and perform the splitting over the network?
> 
> Thanks in advance,
> Drew
> 
ssh user@host -x 'cat large.csv' | your_script
should work pretty well for this.
> -- 
> Posted via http://www.ruby-forum.com/.