I need to do a text lookup for multiple records against a file that contains a key and two results. I found this code:
str=`awk '$1 == search' search=$1 lkup.tbl
It's a little tricky because the first $1 is the key variables location in the lkup.tbl and the second $1 is the parameter passed... (6 Replies)
Hi All,
i have a variable which has a value in it.
RETAILER='JEWL'
i have a text file. Name: file.txt
file.txt
________
WLG 150
JEWL 60
CVS 240
FLN 120
WND 120
I am trying to write a korn script.the script, based on the value in the RETAILER will do a look up against the... (5 Replies)
Hi,
I have the following requirement.
I have one lookup file which contains 15 columns and 7000 records.
Ex:
123,MEDICA,134,145,1178,123,678,345,2345,HP,COL,K12,SR,OX,78919
I have input file which contains 14 columns and 20 million records.Some times the record count is more than 20... (1 Reply)
Hi,
I have the following requirement.
I have one lookup file which contains 15 columns and 7000 records.
Ex:
123,MEDICA,134,145,1178,123,678,345,2345,HP,COL,K12,SR,OX,78919
I have input file which contains 14 columns and 20 million records.Some times the record count is more... (4 Replies)
I have two files ,File1 lookup to file2 based on 1st&3rd against 1st and 2nd column and produce the following o/p
File1
450000|USD|USD
450006|GKSGD|SGD
450002|XSGD|SGD
File2
-----
450000|USD|2000.00|10000.000
450006|SGD|1000.200|3000.000
450002|SGD|3000.000|20000.00
O/p
... (4 Replies)
Write a quick shell snippet to find all of the IPV4 IP addresses
in any and all of the files under /var/lib/output/*, ignoring
whatever else may be in those files. Perform a reverse lookup on
each, and format the output neatly, like "IP=192.168.0.1,
... (0 Replies)
Hi,
need your help to lookup these 2 files
main.txt
RNPMS01,PMS717W_Marasi,CXP9016141/1_R7G04,EXECUTING
RNPMS01,RAP765W_BakaranBatu,CXP9014346/1_R6AG03,EXECUTING
RNPMS01,RNPMS01,CXP9014711/2_R5Z,EXECUTING
RNPMS01,TBT510W_Bandar_Utama,CXP9014346/1_R6AG03,EXECUTING... (8 Replies)
I have the below 2 files:
1) Third field from file1.txt should be compared to the first field of lookup.txt.
2) If match found then third field, file1.txt should be substituted with the second field from lookup.txt.
3)Else just print the line from file1.txt.
File1.txt:... (4 Replies)
Hi All,
I want to lookup name for an id in col2 input from another file and add the name to each line.
Input 1
comp100001_c0_seq1 At1g31340 30.40 569 384 11 3 1673 313 834 7e-62 237
comp100003_c0_seq1 At1g35370_2 35.00 80 50 ... (7 Replies)
A text file has two logs of same event & both logs have to be correlated into a single line before same can be processed further
RAW
OPERATING LOG
Date Month Year Time Event
10 JAN 2014 1000 4
11 APR 2013 1230 2
12 FEB 2014 ... (7 Replies)
Discussion started by: newageBATMAN
7 Replies
LEARN ABOUT MINIX
join
JOIN(1) General Commands Manual JOIN(1)NAME
join - relational database operator
SYNOPSIS
join [-an] [-e s] [-o list] [-tc] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If file1 is `-', the standard
input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2.
Fields are normally separated by blank, tab or newline. In this case, multiple separators count as one, and leading separators are dis-
carded.
These options are recognized:
-an In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-e s Replace empty output fields by string s.
-o list
Each output line comprises the fields specified in list, each element of which has the form n.m, where n is a file number and m is a
field number.
-tc Use character c as a separator (tab character). Every appearance of c in a line is significant.
SEE ALSO sort(1), comm(1), awk(1).
BUGS
With default field separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.
The conventions of join, sort, comm, uniq, look and awk(1) are wildly incongruous.
7th Edition April 29, 1985 JOIN(1)