I'm looking for a grep pattern.

Given the below code, I'd like to have reduce it to Slug,0,58,0,58
which I will convert to .xls. So I want only the data from 5 fields
(name, in, out, start, end), and I want to eliminate the field names
and the other fields. If someone could send the pattern to my email:
mrkimmosley@gmail.com it would be greatly appreciated.

Thanks,

Kim

<clipitem id="Slug">
<name>Slug</name>
<duration>3901</duration>
<rate>
<ntsc>FALSE</ntsc>
<timebase>30</timebase>
</rate>
<in>0</in>
<out>58</out>
<start>0</start>
<end>58</end>
<pixelaspectratio>NTSC-601</pixelaspectratio>
<enabled>TRUE</enabled>
<alphatype>none</alphatype>
<file id="Slug1">
<mediaSource>Slug</mediaSource>
<rate>
<timebase>30</timebase>
</rate>
<duration>3600</duration>
<media>
<video>
<duration>3600</duration>
<samplecharacteristics>
<width>720</width>
<height>480</height>
</samplecharacteristics>
</video>
<audio>
<samplecharacteristics>
<samplerate>48000</samplerate>
<depth>32</depth>
</samplecharacteristics>
<channelcount>2</channelcount>
</audio>
</media>
</file>
<sourcetrack>
<mediatype>video</mediatype>
</sourcetrack>
<fielddominance>lower</fielddominance>
</clipitem>

--
You received this message because you are subscribed to the
"BBEdit Talk" discussion group on Google Groups.
To post to this group, send email to bbedit@googlegroups.com
To unsubscribe from this group, send email to
bbedit+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/bbedit?hl=en
If you have a feature request or would like to report a problem,
please email "support@barebones.com" rather than posting to the group.