Devam Ediyor

Lookup program in Perl

Im looking for some one to develop a Perl script which can be run locally to amend a column with in a CSV file based on a REGEX match.

To better explain this, the program should work as follows.

Their will be 4 main files:

MASTER FILE (READ ONLY): Their will be a master CSV file which will be generated by an external system on a daily basis. This file will contain a column which we will use to do a REGEX (lookup column) match against and another column where the output of the match will be inputted in to.

LOOKUP FILE (READ ONLY): The look up file is also a CSV file and will only contain 2 columns. The first column will be used to match against the lookup column in the master file and the corresponding column is inputted in to the other column with in the master file.

OUTPUT FILE (WRITE): The output file is simply a copy of the master file with the amended lookups.

CONFIG FILE (READ ONLY): the perl script will be complied in to an exe so any changeable variables such as column id and file location will be configured within this file.

Lookup process

The lookup process will start by trying to match the first 4 chars (if match - it inputs the corresponding field). If this fails it will do another lookup but this time on the first 3 chars and then the first 2 chars. If not match is made no value is inputted in to the field.

Lookup file(s)

Its possible that there may be more than one lookup file. i.e 3 or 4 different files. Therefore the program needs to be intelligent enough to know which lookup file to use on a per row basis. This will be done either by using a identifier in a third column within the master file or by using a certain naming convention of the master file. The preferred way can be chosen in config file.

Beceriler: Perl

Daha fazlasını görün: using regex in c, regex in c, LOOkup, develop the program, program needs, perl read config, match columns perl script, perl script read csv file, perl output, write script run program, program process csv files, file csv exe, program needs write, exe csv, csv exe, config file perl, program copy files, perl match script, lookup script, script copy perl, program run exe, process csv file csv, perl script read columns csv file, perl script read columns, perl script copy file file

İşveren Hakkında:
( 8 değerlendirme ) chester, United Kingdom

Proje NO: #4435113

Seçilen:

lepoitr

I'm interested in that project. I'm experienced perl web developer and linux administrator.

1 gün içinde 84£ GBP
(4 Değerlendirme)
3.7

5 freelancer bu iş için ortalamada 98£ teklif veriyor

Mindon

check the PMB please,thanks.

in 2 gün içinde100£ GBP
(52 Değerlendirme)
6.0
vkoder

Hi i can do this

in 2 gün içinde55£ GBP
(0 Değerlendirme)
0.0
zkutch

Hello. More 20 years programming experiense.

in 0 gün içinde100£ GBP
(0 Değerlendirme)
0.0
KrunkSystems

Hi, I'm 8+ years experienced professional in Perl scripting, worked in leading global MNCs like HCL, Credit-Suisse and has a strong technical background. Please check PM for more details

in 7 gün içinde150£ GBP
(0 Değerlendirme)
0.0