Extracting text

[IMAUser]

Hi

I have a file ( Name errorfile.txt) full of lines like the one below

$APP_SCR/dwh_exit_error.scr "$?" "Error in <dwh_hub_if_ow_build_if0005.sql> Exiting"

I need to extract the filename within < >

I tried doing a
awk '{ sub(/^[^>]*>/,""); sub(/<.*$/,""); print $0 } ' errorfile.txt

but it comes back with syntax errors and I cant figure out why.

Any ideas pls ?

 

[PHV]

Something like this ?
sed -e 's!^.*<!!;s!>.*!!' errorfile.txt

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[Ygor]

Try..

awk '{ sub("^[^<]*<",""); sub(">[^>]*$",""); print $0 } ' errorfile.txt

Or..

awk 'match($0,"<.*>") {print substr($0,RSTART+1,RLENGTH-2)}' errorfile.txt

 

[futurelet]

Make the "<" and the ">" field separators:a

[b]
awk -F'<|>' 'NF==3{print $2}'
[/b]

 

[aigles]

The same with alternate field separator specification :

awk -F'[<>]' 'NF==3{print $2}'[code]


Jean Pierre.