topic Re: AWK difficulties in Operating System - HP-UX

AWK difficulties

ROSS HANSON — Wed, 29 Sep 2010 13:44:36 GMT

On a string, how do I extract the string at field $9 to the end of the line.

It's the "end of the line" I do not understand

Re: AWK difficulties

James R. Ferguson — Wed, 29 Sep 2010 13:55:54 GMT

Hi Ross:

# X="a b c d e f g h i j k"

# echo $X|awk '{for (i=9;ii j

Regards!

...JRF...

Re: AWK difficulties

James R. Ferguson — Wed, 29 Sep 2010 14:14:30 GMT

Hi (again):

Sorry, the last post has a fence-post error. The code should have been:

# echo $X|awk '{for (i=9;i<=NF;i++) {printf "%s ",$i};printf "\n"
i j k

Now, this said, if you wanted to preserve the exact whitespace spaceing between fields you could use:

# awk '{print substr($0,index($0,$9))}' myfile

...as for example

# cat myfile
a b c d e f g h i j k
a b c d e f g h i j k

awk '{print substr($0,index($0,$9))}' myfile
i j k
i j k

Regards!

...JRF...

Re: AWK difficulties

ROSS HANSON — Wed, 29 Sep 2010 14:20:50 GMT

which part tells me from "i" to the end of the line?

Re: AWK difficulties

Hein van den Heuvel — Wed, 29 Sep 2010 14:53:45 GMT

>>> which part tells me from "i" to the end of the line?

In the first method JRF shows that would be : i=9;i<=NF;i++

The NF is the Number-of-Field = "the end"

In the second method JRF proposes to just look for the byte offset where field 9 starts, and use that as the start of a string to extract. I like that, notably to preserve spacing.
But be careful that field 9 is indeed unique.
I typically 'help' that by adding separators (spaces) around the target string.

$ X="a b c d e if g h i j k l m"
$ echo $X| awk '{print substr($0,index($0,$9))}'
if g h i j k l m
$ echo $X| awk '{print substr($0,index($0," " $9 " ") + 1)}'
i j k l m

Obligatory PERL variant....

$ echo $X| perl -lane 'print join " ",@F[8..@F]'
i j k l m

Print the join of a slice of the array @F, set up by -a, using a space to join.

The slice starts at element 8 ( Perl arrays are 0 based).
It ends at the scalar value for @F which is the number of elements in @F (but in a pinch 999 will work fine as well)

hth,
Hein

Re: AWK difficulties

James R. Ferguson — Wed, 29 Sep 2010 17:14:54 GMT

Hi (again):

Your profile shows that you have assigned points to 60 of 436 responses to your questions. When you are satisfied with the help you have received, please assign points as a way of saying "thanks" and as a breadcrumb for future trollers:

http://forums.itrc.hp.com/service/forums/pageList.do?userId=CA238734&listType=unassigned&forumId=1

...JRF...

Re: AWK difficulties

Laurent Menase — Wed, 29 Sep 2010 17:27:00 GMT

while read a
do
set -- $a
shift 6
echo $*
done

Re: AWK difficulties

Hein van den Heuvel — Wed, 29 Sep 2010 20:20:39 GMT

Ross, thanks for the feedback.

It suggest that we interpreted the question(s) different from the way you intended them.

Can you perhaps provide concrete input and output examples and show what you tried so far?

Can you humor me and explain why you believe that JRF did not really answer the question asked with the limit information available in the question?

Ditto for my further explanation?
I don't need no points, but would like to understand the large disconnect.

Personally I thought Laurent's suggestion was great although admittedly it is not awk as per subject line.

Cheers,
Hein

Re: AWK difficulties

Laurent Menase — Wed, 29 Sep 2010 20:36:00 GMT

I mean "shift 8" not 6 to get $9 to end of line

else

cut -d " " -f 9-

to the "end of the line" means usually for instance:
if the line is
1 2 3 4 5 6 7 8 9 10 11 12
$1 is 1
$2 is 2
....
$9 is 9
$9 to the end of the line is
9 10 11 12

Re: AWK difficulties

ROSS HANSON — Wed, 29 Sep 2010 20:40:23 GMT

I am just trying to compare two systems. So, I thought by using the awk command to extract only the fields that I wanted would be better than the cut command

Re: AWK difficulties

James R. Ferguson — Wed, 29 Sep 2010 20:58:05 GMT

Hi (again):

> So, I thought by using the awk command to extract only the fields that I wanted would be better than the cut command

If all you are doing is comparing a string of fields, either 'awk' or 'cut' will work as we have described. AWK becomes very powerful when you want to match *and* extract (among other things).

As we say in the Perl community, TMTOWTDI :-)

As for points, thanks. Remember, every response is available for your evaluation and there is no limit to how many total points you can assign in any one thread.

http://forums11.itrc.hp.com/service/forums/helptips.do?#34

Regards!

...JRF...

Re: AWK difficulties

Dennis Handly — Thu, 30 Sep 2010 05:42:34 GMT

>I thought by using the awk command to extract only the fields that I wanted would be better than the cut command

Yes, awk(1) is much better than the cut(1) command in extracting fields, especially if you have a variable number of spaces/tabs between fields because of this:
Adjacent field delimiters delimit null fields.

>Hein: But be careful that field 9 is indeed unique. I typically 'help' that by adding separators (spaces) around the target string.

That won't help if you have duplicate fields. You may have to scan each field to see if it matches, then use index() that many times.