Re: Sed advice needed

[Tyler MacDonald <tyler@yi.org>]

Piers Kittel <debian@biased.org> wrote:
> "181","1324.014027","111.111.111.111","111.111.111.111","RTP","Payload t 
> ype=ITU-T H.261, SSRC=2008229573, Seq=54520, Time=1725612773, Mark"
> "185","1324.078941","111.111.111.111","111.111.111.111","RTP","Payload t 
> ype=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