topic Re: awk cmd in Operating System - HP-UX

awk cmd

Jon Thomas_1 — Mon, 12 Apr 2004 17:44:35 GMT

I am attempting to extrapolate data from a large 20 meg text file by using the awk command. For $1 of each row there are 7 digit numbers. I am trying to extract selective consecutive lines of data and >> to fileXYZ by defining the range of numbers in $1 i.e. [43210-43310] that is desired - Is there a simple way of accomplishing this without doing complicated loop statements?

Re: awk cmd

Rodney Hills — Mon, 12 Apr 2004 17:59:28 GMT

ranges can be done-

awk '/^43210/,/^43310/{ print}' yourfile

HTH

-- Rod Hills

Re: awk cmd

Sundar_7 — Mon, 12 Apr 2004 18:03:26 GMT

you can use sed too

sed -n '/^43210/,/^43310/p' input >> output

Re: awk cmd

KapilRaj — Tue, 13 Apr 2004 00:15:21 GMT

Is this a simple way ?.

If you want to get lines of yourfile from $FROM_LINE to $TO_LINE,

cat yourfile |head -$TO_LINE |tail -`echo "$TO_LINE - $FROM_LINE " |bc`

Regds,

Kaps

Re: awk cmd

SANTOSH S. MHASKAR — Tue, 13 Apr 2004 01:09:55 GMT

I assume the Date at $1 that u want to fetch to be
00043210 and 00043310 since u have mention that $1 is a 7 digit num.
If so then try this

$ cat Your_text_file|awk -F Field_seperator '$1 >= 43210 && $1 <= 43310 {print $0}' >> XYZ

if u have fields seperated by white spaces then try this

$ cat Your_text_file|awk '$1 >= 43210 && $1 <= 43310 {print $0}' >> XYZ

-Santosh