The above script will give the print out all lines in file2 that 'match' with record in file1. Is possible to print unmatched line? expected print out for unmatched record as below example, if CXP9016868/1_R5G08 is not in the record:
looking forward for reply
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)
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)
Hi Experts,
I need you help in coding the below scenario in unix. Please help
Lets say i have below 2 records in my file1
a;b;c
a;d
and in file 2 , i have the below information
a:alpha
b:beta
c:code
d:delta
then i want to lookup on file2 and replace my content in file... (2 Replies)
Discussion started by: ashishagg2005
2 Replies
LEARN ABOUT HPUX
nsquery
nsquery(1) General Commands Manual nsquery(1)NAME
nsquery - query the Name Service Switch backend libraries
SYNOPSIS
lookup_type lookup_query [lookup_policy]
DESCRIPTION
is used to find the Name Service that returned the response to a or function call. This application is Name Service Switch aware and fol-
lows the lookup policies in The supported lookup_type values are:
Used to resolve host name or IP Address lookups.
Used to resolve user name or UID lookups.
Assumes that a numeric value is a UID. This option is to be obsoleted. Use and instead.
Used to resolve user name lookups.
Used to resolve UID lookups.
Used to resolve group name or GID lookups.
Assumes that a numeric value is a GID. This option is to be obsoleted. Use and instead.
Used to resolve group name lookups.
Used to resolve GID lookups.
Used to resolve host name or IP Address lookups.
Only IPv6 and IPv4-mapped IPv6 address will be displayed for host name lookups.
The lookup_query can either be a host name, IP Address (IPv4 only), user name, user ID, group name, or group ID.
The lookup_policy must be a valid lookup policy described in nsswitch.conf(4). If the policy is invalid, the system default policy will be
used. The default values for lookup_policy are:
dns [NOTFOUND=return] nis [NOTFOUND=return] files
files nis
files nis
dns [NOTFOUND=return] files
will display the lookup policy being used, the name of the service being queried, and the result of the query.
EXAMPLES
Lookup host hondo using the default hosts lookup policy.
Lookup host with ip address 15.204.204.204 using "dns files" as the hosts lookup policy.
Lookup user dog using "ldap" as the passwd lookup policy.
Lookup user ID 105 using the default passwd lookup policy.
Lookup group wayne using group lookup policy "nis [NOTFOUND=RETURN] files".
Lookup group 22 using the default group lookup policy.
Lookup host rio using "dns" as the ipnodes lookup policy.
RETURN VALUE
returns the following values:
Success.
Invalid Usage.
Unknown Action.
No match found in any name services queried.
WARNINGS
The and lookup_type values are to be obsoleted. For use or instead. For use or instead.
AUTHOR
was developed by Hewlett-Packard.
SEE ALSO nsswitch.conf(4).
nsquery(1)