Using grep and cut within awk

bittoo · #1 (**permalink**) 2 Weeks Ago

Hi

My input file looks like as follows: say a.txt

Code:

"aaaa cc","224 AW","ss cccccc","P06 09/10","dddddd"
"aaaa cc","224 AW","ss cccccc","P06 09/10","dddddd"
"aaaa cc","224 AW","ss cccccc","P06 09/10","dddddd"
"aaaa cc","224 AW","ss cccccc","P06 09/10","dddddd"
"aaaa cc","224 AW","ss cccccc","P06 09/10","dddddd"

There is another file b.txt which acts like lookup of "AW" in a.txt, like

Code:

1 AW
2 AS
.....

My output should be like:

Code:

aaaa      2242009W1000001(last 5 characters -> 00001 is look up value for AW from b.txt).

Am able to achieve till "aaaa 2242009W10" using the following command

Code:

sed -e 's/ /,/g' -e 's/\//,/g' -e 's/"//g' a.txt|awk -F"," '{printf "%-10s%3s%s%s%s%s\n",$1,$3,"20",$8,"W",$9}'

Kindly help in getting the "grep AW b.txt| cut -d" " -f1" part in awk command itself, so that seperate script can be avoided.

Thanks in Advance.

aigles · #2 (**permalink**) 2 Weeks Ago

Try and adapt the following awk script :

Code:

awk -F '[[:space:],/]' '
NR==FNR { lookup[$2] = $1 ; next }
{
   gsub(/"/,"");
   printf "%-10s%3s20%sW%s%05d\n",$1,$3,$8,$9,lookup[$4];
}
' b.txt a.txt

jean-Pierre.

Scrutinizer · #3 (**permalink**) 2 Weeks Ago

Code:

sed -e 's|"||g;s|[ /]|,|g' b.txt a.txt |awk -F, '!$3{A[$2]=$1;next}{printf "%-10s%s20%sW%s%05d\n",$1,$3,$8,$9,A[$4]}'

bittoo · #4 (**permalink**) 1 Week Ago

Both the commands work perfectly.. Can u guys please explain
"!$3{A[$2]=$1;next}" part of the command.. Thanx a lot for ur help

Scrutinizer · #5 (**permalink**) 1 Week Ago

Sure:
If $3 does not exist (in other words: if the input originates from b.txt) then set the array A with key $2 to the value of $1. next means skip the next commands and re-enter the loop. The rest of the code gets executed when $3 contains a value, i.e. when the input originates from a.txt.

bittoo · #6 (**permalink**) 1 Week Ago

Thanks Scrutinizer....Understood much better now..

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
\| help \| unix \| grep (GNU grep) 2.5.1 \| advanced regex syntax	MykC	UNIX for Dummies Questions & Answers	4	10-15-2009 10:52 AM
\| help \| unix \| grep - Can I use grep to return a string with exactly n matches?	MykC	UNIX for Dummies Questions & Answers	7	10-13-2009 01:57 PM
MEM=`ps v $PPID\| grep -i db2 \| grep -v grep\| awk '{ if ( $7 ~ " " ) { print 0 } else	hariza	Shell Programming and Scripting	4	09-18-2008 02:56 AM
grep and fetching lines after grep	arghya_owen	Shell Programming and Scripting	2	07-16-2008 07:25 AM
Make grep -c display like grep -n?	Jerrad	Shell Programming and Scripting	2	08-25-2006 12:20 AM

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:


	Powered by