Sponsored Content
Full Discussion: Performing lookup quickly
Top Forums Shell Programming and Scripting Performing lookup quickly Post 302590410 by dendright on Monday 16th of January 2012 05:36:57 AM
Old 01-16-2012
Performing lookup quickly

Hello,

Have been trying to develop a script that reads a string from an input file then looks up that string in a reference file to get a number, then inset that number back into the original file at a certain point (_____):
Code:
Input File:
HARRY   JON     _____     AA  M N
PETER   PIE     _____     BB  M Y
SARAHAASJOHNASAS_____     CC  F Y
 
Lookup File:
AA 95321
BB 75330
CC 91211

Becomes:
HARRY   JON     95321     AA  M N
PETER   PIE     75330     BB  M Y
SARAHAASJOHNASAS91211     CC  F Y

I tried rexx first but it was painfully slow probably because the lookup file is 167K lines long!

What is the fastest way to perform this kind of search in unix and can anyone give an example!

Thanks
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

please help quickly..

I want to pass arguments to a sh program and I want to use these arguments in the program as variables? Will I use argc and argv in a main function can anyone around me write the full code please for example when I write in th command sh myprogram.sh argument1 argument2 I want to use... (1 Reply)
Discussion started by: walnut
1 Replies

2. UNIX for Dummies Questions & Answers

need solution for this quickly. please quickly.

Write a nawk script that will produce the following report: ***FIRST QUARTERLY REPORT*** ***CAMPAIGN 2004 CONTRIBUTIONS*** ------------------------------------------------------------------------- NAME PHONE Jan | ... (5 Replies)
Discussion started by: p.palakj.shah
5 Replies

3. UNIX for Advanced & Expert Users

Clueless about how to lookup and reverse lookup IP addresses under a file!!.pls help

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

4. UNIX for Dummies Questions & Answers

changing directory quickly without cd ..

Hi, I am in /home/development/project/abc directory. Now I want to remove one file which is kept in /trial/dev/<file> directory. I would like to do it in one command. I tried changing directory in one command like: pwd /home/development/project/abc cd ~/trial/dev/ bash: no command... (2 Replies)
Discussion started by: palak08
2 Replies

5. UNIX for Advanced & Expert Users

slow performing system

Friends Greetings. I have a RedHat 5.7 64bit virtual server on VMware ESXi 4.1. This server and other Redhat Servers are running very slow. I did some stats collection on ESXi and looks like Linux is holding the disk IO. I am not sure what is causing this behavior. On Linux I checked the CPU... (4 Replies)
Discussion started by: sdewal
4 Replies

6. Shell Programming and Scripting

Please Help quickly

Hello everyone! I am new here and by new i don't mean only in this place, but in this shell scripting area. I started learning about Operation Systems only 2 months ago. I want to learn more but i found a problem which I don't really know how to solve. :confused: I have a directory with 4... (2 Replies)
Discussion started by: Stripes07
2 Replies

7. Solaris

Service is restarting too quickly

Hi guys, one of my services in solaris 10 is in maintenance mode. When I checked why, the reason is that the service is "restarting too quickly." # svcs -x svc:/application/management/snmpdx:default svc:/application/management/snmpdx:default (Sun Solstice Enterprise Master Agent) State:... (2 Replies)
Discussion started by: cjashu
2 Replies

8. Programming

Performing a while for two files

Hi, This is for Perl. I have a while loop, and would like to process two files, the formats are given below : access access.<previousday>-* How can perform a while loop on both logs, while creating the logic for access.<previousday>-* to get format like "access.20130615-124139" when... (11 Replies)
Discussion started by: susankoperna1
11 Replies

9. Shell Programming and Scripting

Performing aggregation in File

Hi, I need help in UNIX shell script to handle the following: I have file called File1.txt which contains data something like below: LibraryName|BookName|Flag-Indicator|COUNT LIB1|BOOK1|A|12 LIB1|BOOK1|A|2 LIB2|BOOK2|I|1 LIB2|BOOK1|I|4 LIB1|BOOK2|A|12 LIB1|BOOK1|I|22... (3 Replies)
Discussion started by: vfrg
3 Replies
GPSTRANS(1)							    GPS Utility 						       GPSTRANS(1)

NAME
gpstrans - communicate with Garmin GPS receiver SYNOPOSIS
gpstrans [ options ] [ file ] DESCRIPTION
gpstrans allows the user with a Garmin GPS receiver to upload and download waypoints, routes, almanacs (satellite orbital elements) and trackroutes. If file is not supplied, data will be read from stdin (-ux switch) or written to stdout (-dx switch). OPTIONS
-pport set serial I/O device -s set datum, format, offset, and device interactively, and save them in $HOME/.gpstrans. -i identify connected GPS -o turn off GPS device -t get time from GPS -ts get time from GPS and set system time on host -dx download data indicated by x: r=route, t=track, w=waypoint, a=almanac -m With -dt, downloads track data in the format which can be displayed by Mayko mXmap(1). With -dr or -ur, downloads or uploads route data in a format compatible with Mayko mXmap. -ux upload data indicated by x: r=route, t=track, w=waypoint, a=almanac -v print program version. --verbose Increase verbosity. --debug Add debug printouts. --help Print help text. CONNECTION
For a DB-25 connector, you may need to connect pin 4, 5 and 6, 8, 20 together. This sets handshake signals so that your workstation can use the serial port to communicate with the GPS. 1 ### ##### o o o # # # o # o o o o o o o o o o o # o o o o o Connect the Garmin cable as follows: 2 3 7 o o o o o o o o o o o o o o o o o o o o o o o o o Pin 2 goes to DATA IN (White) Pin 3 goes to DATA OUT (Brown) Pin 7 goes to GROUND (Black) If it doesn't work in this way, try exchanging pins 2 and 3 at the connector. The circular connector on a Garmin GPS II receiver can be wired to a DB-9 connector as follows: _____ _____,-----, 3 / 4 | | | | o o | | | |_____ | < <- groove -> |=====| |----,| | o o | | | | || 2 _____ / 1 |_____| | || `-----' || || views are looking || into connector || at each end of cable || || || 5 3 2 ________ || o o o o o | \___________|| o o o o |_________,------------' DB-9 pin 2 goes to circular connector pin 2 DB-9 pin 3 goes to circular connector pin 4 DB-9 pin 5 goes to circular connector pin 3 other pins are not connected (Note: the pin numbers for the circular connector are arbitrary, and may not match the `official' numbers.) If your plug is more recent than the one above (ex: etrex) then you need DB-9 or DB-25 to be connected to your Garmin GPS like this: _____,-----, POWER(+) | | | groove --> |=====| |_____ DATA IN | | |----,| DATA OUT | | | || GROUND(-) |_____| | || `-----' || || || || || || || ________ || | \___________|| |_________,------------' DB-25 : 2 3 7 o o o o o o o o o o o o o o o o o o o o o o o o o Pin 2 goes to DATA IN (White) Pin 3 goes to DATA OUT (Brown) Pin 7 goes to GROUND (Black) DB-9: 5 3 2 o o o o o o o o o pin 2 goes to DATA IN (White) pin 3 goes to DATA OUT (Brown) pin 5 goes to GROUND (Black) other pins are not connected For testing, you might try setting the GPS to NMEA-Output and using a terminal emulator program like Kermit. The GPS will send a data record every 2 seconds. As long as you don't see any data on your computer, gpstrans won't work. After finishing the test, be sure to set your GPS receiver to GRMN/GRMN. ENVIRONMENT
GPSDEV Serial I/O device (overrides contents of $HOME/.gpstrans, and is overridden by -p switch). FILES
$HOME/.gpstrans Has user preferences for datum, format, offset, and serial I/O device (see -s switch, above). AUTHOR
GPStrans is Copyright 1995 by Carsten Tschach <tschach@zedat.fu-berlin.de>. The datum translation routines are based on the program MacGPS from John F. Waers <jfwaers@csn.net>. Mayko mXmap output format by Matthias Kattanek <mattes@ugraf.com>. German Grid by Andreas Lange <andreas.lange@rhein-main.de>. etrex support by Joao Seabra CT2GNL - <seabra@ci.aac.uc.pt>. Other Garmin formats added by Jim Van Zandt <jrvz@comcast.remove.me.net>. SEE ALSO
mxmap(1), GPSMan - 2006 May 7 GPSTRANS(1)
All times are GMT -4. The time now is 01:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy