07-31-2008
lookup in unix
i am having one file which is of CSV format with two fields client_id and client_nbr.The sample data is lke below
ABC,1250
CDE,1520
EFG,1000
PQR,1800
The client nbr for these clients change frequently.So i want to create one lookup file every week for the changed client and run a script sothat in original CSV the client nbr will change.
Say for week1 the client nbr for two clients changed
ABC,1000
PQR,1500
This will be placed in a CSV file(lookup file)
After running the script the output in the original file should be
ABC,1000
CDE,1520
EFG,1000
PQR,1500
Please help me writing the script.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
We have Unix configured as our external DNS, forward DNS is working properly, however Reverse lookup is not working. Any idea what the problem is? I have checked the named.boot and .rev file and everything seems to be correctly. However it appears that the reverse zone file in the named.boot... (2 Replies)
Discussion started by: cassy
2 Replies
2. UNIX for Dummies Questions & Answers
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)
Discussion started by: pavan_test
5 Replies
3. Shell Programming and Scripting
Hi All
I have got a fixed length file of 80bytes long.The first 4bytes of each record represents a client_number.I need to modify the client number based on another lookup file.
The lookup file contains 2 fields and a comma delimited file.The first line of the lookup file contains the header... (5 Replies)
Discussion started by: dr46014
5 Replies
4. UNIX for Advanced & Expert Users
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)
Discussion started by: choco4202002
0 Replies
5. Shell Programming and Scripting
I have a lookup file in unix say /data/lkp.dat (First line is header and space delimited) and the content is shown below.
Another file which contains the job_name and rec_count lets say /data/data_file.dat(no header pipe delimited file).
Now i want to do a lookup on job_name and my output should... (3 Replies)
Discussion started by: dr46014
3 Replies
6. UNIX for Dummies Questions & Answers
Hi there
i am not sure how to explain my problem.
i need to run a script to give me the results of all my unix hosts that do not have reverse lookup activated (for lack of a better word), i need to give this to out Server guys to add it part of the AD rules. So what i need is a script to... (0 Replies)
Discussion started by: brian112
0 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I have an input file which contain below records:
a,1
b,2
c,3
a,10
b,34
i have a reference file which contains below records:
a,AA
b,BB
c,CC
My required output is : (3 Replies)
Discussion started by: pandeesh
3 Replies
8. Shell Programming and Scripting
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)
Discussion started by: gina.lizar
7 Replies
9. Shell Programming and Scripting
I have 2 fixed length files input#1 & input#2. I want to match the rows based on the value in position 37-50 in both files (pos 37-50 will have same value in both files).
If any matching record is found then cut the value against company code & Invoice number from input file #1 (position 99 until... (3 Replies)
Discussion started by: Lingaraju
3 Replies
10. Shell Programming and Scripting
Hey everyone,
I am trying to extract column values from a column in a tab-delimited text file and overlay them in a 2nd tab-delimited text file using a V-lookup type script in Unix bash.
These are the 1st few rows of the 1st input file IN1:
rsid chromosome position allele1 ... (10 Replies)
Discussion started by: Geneanalyst
10 Replies
LEARN ABOUT DEBIAN
metasys
METASYS(8) NUT Manual METASYS(8)
NAME
metasys - Driver for Meta System UPS equipment
NOTE
This man page only documents the hardware-specific features of the metasys driver. For information about the core driver, see nutupsdrv(8).
SUPPORTED HARDWARE
The metasys driver was written with the "Meta System UPS Protocol Rev.1.12" kindly supplied from Meta System.
The driver should support all the common features of the ups models:
o HF Line (/2) 1-8 boards
o HF Millennium (810, 820)
o HF TOP Line (910, 920, 930, 940, 950, 970, 980)
o ECO Network (750, 1000, 1050, 1500, 1800, 2000, 2100, 2500, 3000)
o ECO (305, 308, 311, 511, 516, 519, 522, SX, SXI)
o ally HF (800, 1000, 1250, 1600, 2000, 2500)
o Megaline (1250, 2500, 3750, 5000, 6250, 7500, 8750, 10000)
CABLING
The needed cable is a standard pin-to-pin serial cable with at least pins 2, 3, and 5 (on DB9 connector) connected.
EXTRA ARGUMENTS
This driver supports no extra arguments from ups.conf(5).
BUGS
This driver has been tested on Meta System HF Millennium 820 and ally HF 1000 only.
Any information about the use of the driver with the other listed UPS are really welcome.
AUTHOR
Fabio Di Niro <blaxwan@users.sourceforge.net>
SEE ALSO
The core driver:
nutupsdrv(8)
Internet resources:
The NUT (Network UPS Tools) home page: http://www.networkupstools.org/
Network UPS Tools 05/21/2012 METASYS(8)