02-04-2015
Hi RudiC and Don,
Following script worked for me.
Thanks for the guidance.
#!/bin/ksh
> File3.txt
> Unmatched.txt
awk '
BEGIN {
OFS="\t"
out_m = "File3.txt"
out_nm = "Unmatched.txt"
}
NR == FNR {
if(NF) {
a[$1]=$0
}
next
}
function print_77_99() {
out = (mc ? out_m : out_nm)
for(i = 1; i <= lc; i++)
print l[i] > out
for(i = 1; i <= mc; i++)
print m[i] > out
lc = mc = 0
}
$1 == "01" {
if(FNR > 1)
print_77_99()
key = $4 $3 $2
}
$1 == "07" && (key $NF) in a {
m[++mc] = "77\t" a[key $NF]
}
{ l[++lc] = $0
}
END { print_77_99()
}' File2.txt File1.txt
Last edited by High-T; 02-11-2015 at 12:42 AM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi folks
I am not allowed to install GNU grep on AIX.
Here my code excerpt:
grep_fatal () {
/usr/sfw/bin/gegrep -B4 -A2 "FATAL|QUEUE|SIGHUP"
}
Howto the same on AIX based machine?
from manual GNU grep
‘--after-context=num’
Print num lines of trailing context after... (4 Replies)
Discussion started by: slashdotweenie
4 Replies
2. Shell Programming and Scripting
Hi,
I have two comma separated files. I would like to see field 1 value of File1 exact match in field 2 of File2. If the value matches, then it should print matched lines from File2. I have achieved the results using cut, paste and egrep -f but I would like to use awk as it is efficient way and... (7 Replies)
Discussion started by: SBC
7 Replies
3. Shell Programming and Scripting
i have a file containing over 1 million records,and i want to print about 300,000 line containing a some specific words.
file has content.
eg
1,rrt,234
3,fgt,678
4,crf,456
5,cde,drt
6,cfg,123
and i want to print the line with the word fgt,crf
this is just an example,my file is so... (2 Replies)
Discussion started by: tomjones
2 Replies
4. Shell Programming and Scripting
My item was not answered on previous thread as code given did not work
I wanted to print records from file2 where comparing column 1 and 16 for both files find rows where column 16 in file 1 does not match column 16 in file 2
Here was CODE give to issue
~/unix.com$ cat f1... (0 Replies)
Discussion started by: sigh2010
0 Replies
5. Shell Programming and Scripting
Is there a way with aw to print all lines after a string is found
There is a file like this
.......
........
2012/19/11 :11.58 PM some data
lne no date
2012/19/11 :11.59 PM some other data
2012/20/11 :12.00 AM some other data
some line without dates
some more lines without dates... (8 Replies)
Discussion started by: swayam123
8 Replies
6. Shell Programming and Scripting
Hello,
I have two files file 1 and file 2 each having result of a query on certain database tables and need to compare for Col1 in file1 with Col3 in file2, compare Col2 with Col4 and output the value of Col1 from File1 which is a) not present in Col3 of File2 b) value of Col2 is different from... (2 Replies)
Discussion started by: RasB15
2 Replies
7. Shell Programming and Scripting
Hi,
here are few lines present in the logs. I want to grep on Error and print few lines before and after Error word is found
line1
Line2
Line3
Error
Line4
Line5
Line6
Line7
I want the output to be
Line2
Line3
Error
Line5 (1 Reply)
Discussion started by: arghadeep adity
1 Replies
8. UNIX for Dummies Questions & Answers
URGENT HELP IS NEEDED!!
I am looking to move matching lines (01 - 07) from File1 and 77 tab the matching string from File2, to File3.txt. I am almost done but
- Currently, script is not printing lines to File3.txt in order.
- Also the matching lines are not moving out of File1.txt
... (1 Reply)
Discussion started by: High-T
1 Replies
9. Shell Programming and Scripting
Hi,
I need help on a complicated file that I am working on. I wanted to extract important info from a very huge file. It is space delimited file. I have hundred thousands of records in this file. An example content of the inputfile as below:-
##
ID Ser402 Old; 23... (2 Replies)
Discussion started by: redse171
2 Replies
10. Shell Programming and Scripting
In the tab delimited files below I am trying to match $2 in file1 to $2 of file2. If a match is found the awk checks $3 of file2 and if it is greater than 40% and $4 of file2 is greater than 49, the line in file1 is printed. In the desired output line3 of file1 is not printed because $3 off file2... (9 Replies)
Discussion started by: cmccabe
9 Replies
LEARN ABOUT DEBIAN
atr_analysis
ATR_ANALYSIS(1p) User Commands ATR_ANALYSIS(1p)
NAME
ATR_analysis - analyse a smart card ATR
SYNOPSIS
ATR_analysis [ATRstring]
DESCRIPTION
ATR_analysis is used to parse the ATR (Answer To Reset) sent by a smart card.
The command also tries to find the card model using an ATR database stored in a text file smartcard_list.txt.
The smartcard_list.txt file is searched in ./, /usr/local/pcsc/ and /usr/share/pcsc/ directories.
Exemple:
$ ATR_analysis '3B A7 00 40 18 80 65 A2 08 01 01 52'
ATR: 3B A7 00 40 18 80 65 A2 08 01 01 52
+ TS = 3B --> Direct Convention
+ T0 = A7, Y(1): 1010, K: 7 (historical bytes)
TB(1) = 00 --> Programming Param P: 0, I: 0
TD(1) = 40 --> Y(i+1) = 0100, Protocol T = 0
-----
TC(2) = 18 --> Work waiting time: 960 x 24 x (Fi/F)
+ Historical bytes: 80 65 A2 08 01 01 52
Possibly identified card:
3B A7 00 40 18 80 65 A2 08 01 01 52
Gemplus GPK8000
BUGS
Maybe many bugs since I am not a ISO 7816 expert.
FILES
smartcard_list.txt
SEE ALSO
pcscd(8), pcsc_scan(1)
AUTHOR
Ludovic Rousseau <ludovic.rousseau@free.fr>
Version: 1.3 October 2005 ATR_ANALYSIS(1p)