How to select a single string

Shell Programming and Scripting
1

I am learning sed/awk. So, bear with me.

I have successfully created a list (based on sed) which looks like:

<cl:item href="clsysrev/XTT004/XTT05064.xml" productSubtitle="animals" unitStatus="today"IR">
<cl:item href="clsysrev/XTT007/XTT08581.xml" productSubtitle="humans" unitStatus="new" unitType="IR" iconStatus="true">
<cl:item href="clsysrev/XTT007/XTT08502.xml" productSubtitle="humans" unitStatus="new" unitType="IR">
<cl:item href="clsysrev/XTT004/XTT05063.xml" productSubtitle="animals" unitStatus="journal">
<cl:item href="clsysrev/XTT003/XTT04331.xml" productSubtitle="humans" unitStatus="edited (no change to conclusions)" unitType="IR">

My objective now is to create a list like:

XTT05064
XTT08581
XTT08502
XTT05063
XTT04331

The command I am trying to use is:

sed -e "s/\/XTT*xml$/p" myfile.txt > finalfile.txt

but I got stuck, and could not figure out how to get it done.

grateful for any tips.

Alonso

2

One of the sed solution..

sed 's/.*\/\(.*\).xml.*/\1/' inputfile > outfile
3 
 
bash-3.00$ nawk -F"[\/|\"]" '{print substr($4,1,length($4)-4)}' /tmp/myfile
XTT05064
XTT08581
XTT08502
XTT05063
XTT04331
4

Thank you very much for your time. both suggestions worked like a charm.

Cheers!

Alonso