while read and output from two files

phpshell · 05-21-2014, 02:10 AM

hello
I am looking to do this with same command approach I have two files i just want to gerp the last vaule in the line which is the number if is there or show unknown if does not

file1

Code:

114444444,2,FTTH,DTN,No Dial tone & No Browsing,FBR,Fiber Major Fault,11-444-4444
112221111,2,FTTH,CCO,Can't call some lines,ERR,Err Opening TT#,11-222-1111

using

Code:

cat file1 | awk -F, 'OFS=","{print $4,$5,$6,$7"+"$8}' |  while IFS=+ read f1 f2;do echo -n $f1",";cat file2 | grep $f2 ;done

output

Code:

DTN,No Dial tone & No Browsing,FBR,Fiber Major Fault,CCO,Can't call some lines,ERR,Err Opening TT#,"116-00_MRSTR8888L9:1-1-11-111     116-00_MRSTRD1111    11-222-1111

I am looking to have this output

Code:

DTN,No Dial tone & No Browsing,FBR,Fiber Major Fault,unknown
CCO,Can't call some lines,ERR,Err Opening TT#,"116-00_MRSTRD00OL9:1-1-12-4-12     116-00_MRSTRD1111    11-222-1111

pan64 · 05-21-2014, 02:21 AM

Hi,
file2 is still unknown, and I do not understand what do you really need.
But I have a few comments:

Code:

instead of:
cat file | awk ' ...'
use
awk '...' file
....
also, instead of
cat file | grep  ....
use
grep .... file

I think all these things can be solved with a single awk script, but first we need to know exactly what do we need to implement....

phpshell · 05-21-2014, 02:28 AM

sorry file2

Code:

"116-00_MRSTRD00OL9:1-1-12-4-12    116-00_MRSTRD1111    11-222-1111
"220-00_MRSTRD00OL9:1-1-12-4-124     116-00_MRSTRD1111    11-333-5554
"333-00_MRSTRD00OL9:1-1-12-4-121     116-00_MRSTRD1111    11-555-5111
"444-00_MRSTRD00OL9:1-1-12-4-124     116-00_MRSTRD1111    11-222-5555

just I want to grep 11-222-1111 from file1 also some field should be appear from file 1

Code:

DTN,No Dial tone & No Browsing,FBR,Fiber Major Fault,unknown
CCO,Can't call some lines,ERR,Err Opening TT#,"116-00_MRSTRD00OL9:1-1-12-4-12     116-00_MRSTRD1111    11-222-1111

grail · 05-21-2014, 06:02 AM

So maybe something like:

Code:

awk 'BEGINFILE{if(x)FS=",";x=!(FNR);OFS=","}NR==FNR{a[$NF]=$0;next}{if(!($NF in a))u="unknown";print $4,$5,$6,$7,(u?u:a[$NF]);u=""}' file2 file1

phpshell · 05-22-2014, 12:30 AM

thanks a lot grail
is there any way to do it by while? .because it is very difficult for me to trace it on awk

grail · 05-22-2014, 05:49 AM

awk has done all the heavy lifting so you would need to explain what you mean by trace? What to you is the use of the bash while loop? Especially after pan64 has explained that your current pasting together of multiple commands is a poor way to proceed.

pan64 · 05-22-2014, 05:55 AM

awk has a built-in while loop. I would suggest you to go thru that script and try to understand it. Use the man page of awk and ask if something is not clear...