topic Re: data extraction in Operating System - HP-UX

data extraction

Pando — Tue, 15 Mar 2005 04:30:37 GMT

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.

Re: data extraction

john korterman — Tue, 15 Mar 2005 04:45:16 GMT

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.

Re: data extraction

Peter Godron — Tue, 15 Mar 2005 05:10:50 GMT

Fernando,

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

Regards

Re: data extraction

harry d brown jr — Tue, 15 Mar 2005 07:04:04 GMT

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

live free or die
harry d brown jr

Re: data extraction

Pando — Tue, 15 Mar 2005 19:08:57 GMT

Many thanks to all!