<div>
is this what you mean?<br />
<br />
sed -e 's/,[^,]*,/,/' &lt;&nbsp;csvfile &gt;&nbsp;seperatefile<br />

</div>


is this what you mean?

sed -e 's/,[^,]*,/,/' < csvfile > seperatefile


<div>
Or do you mean something more like this?<br />
<br />
sed -e h -e 's/[^,]*,\([^,]*\),[^,]*/\<wbr />1/p' -e g -e 's/,[^,]*,/,/'<br />

</div>


Or do you mean something more like this?

sed -e h -e 's/[^,]*,\([^,]*\),[^,]*/\1/p' -e g -e 's/,[^,]*,/,/'


<div>
I would do a<br />
<br />
cat infile | cut -d, -f1,3 | tr &quot;&nbsp;&quot; &quot;\012&quot; &gt;outfile<br />
<br />
which should filter out the first and third column separated by<br />
commas and separate them afterwards by a newline...<br />

</div>


I would do a

cat infile | cut -d, -f1,3 | tr " " "\012" >outfile

which should filter out the first and third column separated by
commas and separate them afterwards by a newline...


<div>
<div class="content wysiwyg-content">
I have a csv file like this:<br />
1.3,2.4,4.5<br />
4.0,6.77,3.21<br />
.....<br />
data is delimited by comma, how can I filter out the first and third data on each line <br />
and save into a seperate line?<br />
Thanks.<br />

</div>
</div>


I have a csv file like this:
1.3,2.4,4.5
4.0,6.77,3.21
.....
data is delimited by comma, how can I filter out the first and third data on each line 
and save into a seperate line?
Thanks.


Can sed do this?

Unix is a multitasking, multi-user computer operating system originally developed in 1969 at Bell Labs. Today, it is a modern OS with many commercial flavors and licensees, including FreeBSD, Hewlett-Packard’s UX, IBM AIX and Apple Mac OS-X. Apart from its command-line interface, most UNIX variations support the standardized X Window System for GUIs, with the exception of the Mac OS, which uses a proprietary system.