On 31 May 2007, at 17:49, Tyler MacDonald wrote:
Piers Kittel <debian@biased.org> wrote:"181","1324.014027","111.111.111.111","111.111.111.111","RTP","Payloa d type=ITU-T H.261, SSRC=2008229573, Seq=54520, Time=1725612773, Mark""185","1324.078941","111.111.111.111","111.111.111.111","RTP","Payloa d type=ITU-T H.261, SSRC=2008229573, Seq=54521, Time=1725616276" I need to convert the above to the below: "181","1324.014027","111.111.111.111","111.111.111.111","RTP","54520" "185","1324.078941","111.111.111.111","111.111.111.111","RTP","54521"This *might* work, it depends on the rest of your dataset; sed -e 's/,"Payload.*Seq=//' -e 's/, Time=.*$/"/' Cheers, Tyler
That wasn't quite perfect, but I worked out a bit how the command works and modified it - it now works like a dream! You're a lifesaver :) I really appreciate this! I will learn exactly how the command works - sed does seem quite powerful.
Thanks again! Regards - Piers