Add values < or eq to 1000 - Page 3

repinementer · #15 (**permalink**) 11-18-2009

Still the same error.
Anyways with out it (\)the script working great. Thank you.
Still I have not cleared the doubts about previous scripts(awk one liners). Whats wrong with the previous scripts?

danmero · #16 (**permalink**) 11-18-2009

Quote:

Originally Posted by repinementer

Still the same error.
Anyways with out it (\)the script working great. Thank you.

My awk(FreeBSD) require (\) backslash

Quote:

Originally Posted by repinementer

Still I have not cleared the doubts about previous scripts(awk one liners). Whats wrong with the previous scripts?

Quote:

Code:

awk 'NR==FNR{a[$1]=$2;next} a[$1] && ($2 <= a[$1]+1000) && ($2 >= a[$1]-1000) {print a[$1], $0}' test1.txt test2.txt

Using the first column value as array key to hold the second column value, because you have multiple records having the same key value (x1 and x2 in this example) each one will overwrite the previous one and only the last one will be saved in array as per your example:

Quote:

Code:

x1    10
x1    100
x2    1000
x2    10000
x3    989
x4    345
x10    8767736477736
xx    234
xy    387889999

repinementer · #17 (**permalink**) 11-18-2009

That make sense. Thanx alot for cooperation.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to pick values from column based on key values by usin AWK	repinementer	Shell Programming and Scripting	16	07-24-2009 09:59 AM
Converting Binary decimal coded values to Ascii Values	gaur.deepti	UNIX for Advanced & Expert Users	3	04-02-2008 01:33 PM
Sunblade 1000	Kawakaze	UNIX for Dummies Questions & Answers	3	03-16-2008 06:32 AM
Can I use both of TCP/IP 10/100 and 100/1000?	trantuananh24hg	Solaris	10	12-28-2007 05:52 AM
Help me spend $1000	John Bruzzese	UNIX for Dummies Questions & Answers	1	12-07-2005 01:14 AM