data extraction

[Pando]

I have a data inside the file

...
...
"P-BC-0504-6041"
...
...

I need to get the 6041 number only.

Can i accomplish this using awk or sed?

Maximum points to all correct reply.

[john korterman · Accepted solution]

Hi,
if the central "P-BC-0504-6041" string is embeded in double quotes, and these are the ones, you could try something very simple:
# awk -F"\"" '{print $2}'
regards,
John K.

[Peter Godron]

Fernando,

cat data.file | cut -d'"' -f2 | cut -d'-' -f4

Regards

[harry d brown jr]

grep ED_ORDERNR FILENAME | sed "s/\(\\"\)\(.*\)\-\(.*\)-\(.*\)-\(.*\)\(\"\<\/ED_ORDERNR\>\)/\5/"

live free or die
harry d brown jr

[Pando]

Many thanks to all!