11-02-2006
lookup table in perl??
hi,
i am very much new in perl and have this very basic question in the same
the requirement is as below:
i have an input file (txt file) in which i have fields invoice number and customer number. Now i have to take input this combination of invoice n customer number and check in a lookup file (pipe delimited txt file) and if the combination exists, then i have to get the new invoice number (present in lookup table) and append this new invoice number into the original record of the input file.
for example:
input file record: aaabbb
invoicenum1customernum1333
lookup record:11111
invoicenum1customernum18888
newinvoicenum1
so now original input record becomes:
aaabbb
invoicenum1customernum1333
newinvoicenum1
i have to use hash array here in perl with keys as invoice and customer number combination, but me not sure how to use it
..
please help me out in solving this...
regards,
Bhups
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Using AIX 5.2, Bourne and Korn Shell.
I have two flat text files. One is a main file and one is a lookup table that contains a number of letter codes and membership numbers as follows:
316707965EGM01
315672908ANM92
Whenever one of these records from the lookup appears in the main file... (6 Replies)
Discussion started by: Dolph
6 Replies
2. 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
3. Shell Programming and Scripting
Hello: I have another question. Please consider the following two sample, tab-delimited files:
File_1:
Abf1 YKL112w
Abf1 YAL054c
Abf1 YGL234w
Ace2 YKL150w
Ace2 YNL328c
Cup9 YDR441c
Cup9 YDR442w
Cup9 YEL040w
...
File 2:
...
ABF1 YKL112W
ACE2 YLR131C (9 Replies)
Discussion started by: gstuart
9 Replies
4. Programming
Good Evening,
I started working on the 17x17 4-colouring challenge, and I ran into a bit of an I/O snag.
It was an enormous headache to detect the differences in very similar 289-char strings.
Eventually, it made more sense to associate a CRC-Digest with each colouring.
After learning... (0 Replies)
Discussion started by: HeavyJ
0 Replies
5. Shell Programming and Scripting
I have a file with the following format
--TABLEA_START--
field1=data1;field2=data2;field3=data3
--TABLEA_END--
--TABLEB_START--
field1=data1;field2=data2;field3=data3
--TABLEB_END--
--TABLEA_START--
field1=data1;field2=data2;field3=data3
... (0 Replies)
Discussion started by: milo7
0 Replies
6. UNIX for Dummies Questions & Answers
Dear all thanks for helping in advance.. Know this should be fairly simple but I failed in searching for an answer.
I have a file (replacement table) containing two columns, e.g.:
ACICJ ACIDIPHILIUM
ACIF2 ACIDITHIOBACILLUS
ACIF5 ACIDITHIOBACILLUS
ACIC5 ACIDOBACTERIUM
ACIC1 ACIDOTHERMUS... (10 Replies)
Discussion started by: roussine
10 Replies
7. Shell Programming and Scripting
Hi Perl Guru,
I'm new to Perl Programming & need some help.
I need to have some kind of similar code template so I can start to work on it.
I'm been reading some forums and did not find anything that are similar so I start to work on it. I've been struggling on how to start it.
Any... (1 Reply)
Discussion started by: devvvt168
1 Replies
8. Shell Programming and Scripting
Hi,
I have an input file and a config file which I need to lookup values in using Perl:
Input file:
ID, Value
COMP0,0
COMP1,1
COMP2,2
COMP3,3
COMP4,3
COMP5,5Config file:
ID, Operation
COMP0,((@COMP1@ + @COMP2@ + @COMP3@) / @COMP4@) + @COMP5@Expected output:
ID, Value
COMP0,7 # This... (0 Replies)
Discussion started by: Subbeh
0 Replies
9. Shell Programming and Scripting
please help solving the following. I have access to redhat linux cluster having 32gigs of ram.
I have duplicate ids for variable names, in the file 1,2 are duplicates;3,4 and 5 are duplicates;6 and 7 are duplicates. My objective is to use only the first occurrence of these duplicates.
Lookup... (4 Replies)
Discussion started by: ritakadm
4 Replies
10. Shell Programming and Scripting
Hi All
I need to pass country code into a pipe delimited file for lookup.
It will search country code (column 3) in the file, if the country code matched, it will return value from other columns.
Here is my mapping file.
#CountryName|CountryRegion|CountryCode-3|CountryCode-2... (5 Replies)
Discussion started by: lafrance
5 Replies
LEARN ABOUT SUNOS
mlib_imagelookup_inp
mlib_ImageLookUp_Inp(3MLIB) mediaLib Library Functions mlib_ImageLookUp_Inp(3MLIB)
NAME
mlib_ImageLookUp_Inp - table lookup, in place
SYNOPSIS
cc [ flag... ] file... -lmlib [ library... ]
#include <mlib.h>
mlib_status mlib_ImageLookUp_Inp(mlib_image *srcdst, const void **table);
DESCRIPTION
The mlib_ImageLookUp_Inp() function maps the source image to the destination image, in place, by using the user-specified lookup table.
The following equation is used:
srcdst[x][y][i] = table[i][srcdst[x][y][i]]
PARAMETERS
The function takes the following arguments:
srcdst Pointer to first source and destination image.
table Pointer to lookup table. The data type of the lookup table is the same as the destination image. The number of entries in
the lookup table is determined by the type of the input image. The format of the lookup table is:
table[channel][index]
The MLIB_BYTE type entries are indexed from 0 to 255. The MLIB_SHORT type entries are indexed from -32768 to -1, then from
0 to 32767. The MLIB_USHORT type entries are indexed from 0 to 65535. The MLIB_INT type entries are indexed from
-2147483648 to -1, and then from 0 to 2147483647.
RETURN VALUES
The function returns MLIB_SUCCESS if successful. Otherwise it returns MLIB_FAILURE.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Interface Stability |Evolving |
+-----------------------------+-----------------------------+
|MT-Level |MT-Safe |
+-----------------------------+-----------------------------+
SEE ALSO
mlib_ImageLookUp(3MLIB), mlib_ImageLookUp2(3MLIB), mlib_ImageLookUpMask(3MLIB), attributes(5)
SunOS 5.10 10 Nov 2004 mlib_ImageLookUp_Inp(3MLIB)