How To Control Sort In Awk?

[lioujian47]

please vist the page first
awk problem

[ghostdog74]

...
print "Thanks to****"substr(topname,RESTART)
...

its RSTART, not RESTART

[lioujian47]

its RSTART, not RESTART

Thanks in advances.
I fixed it, but there are still problems.
anymore good ideas?

[ghostdog74]

show your error messages etc...i am not going to guess what happened.

[lioujian47]

show your error messages etc...i am not going to guess what happened.

ok. please vist again.
i paste 2 pics of my error on it .
I can’t print “***THANKS Dan***” but ”***THANKS Dan Savage”.
print "Thanks to****"substr(topname,RSTART,4)"****" was not a good idea.

Second, I can’t print the sorted names if the last “Thanks to ……” is needed.
Listed are their names (sorted by last names) and phone numbers:

John Goldenrod--(916) 348-4278

Mike Harrington--(510) 548-1278

Archie McNichol--(206) 548-1348

Guy Quigley--(916) 343-6410

Dan Savage--(406) 298-7744

Tom Savage--(40 926-3456

Elizabeth Stachelin--(916) 440-1763

Thanks to all of you for your continued support!

[ghostdog74]

you could try :
1) sort -k2 instead of sort +1
2) try split(topname...) instead of match().
3) instead of system("cat tmp") , you can try

while ( ( getline line < "/path/tmp" ) > 0 )  {
  print line
}

however, i suspect you don't have to use this anymore since you have already print them out with the sort...

[lioujian47]

you could try :
1) sort -k2 instead of sort +1
2) try split(topname...) instead of match().
3) instead of system("cat tmp") , you can try

while ( ( getline line < "/path/tmp" ) > 0 )  {
  print line
}

however, i suspect you don't have to use this anymore since you have already print them out with the sort...

First, Thanks a lot.
Secrond,

 "sort +1"

could be ok in freebsd,

"sort -k +1"

could be right in debian.
Third,

 system("cat tmp")

may work sometimes, that's quite strange!
Forth,

while ( ( getline line < "/path/tmp" ) > 0 )  {
  print line
}

worked beter than system("cat tmp")


thanks again!