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.
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.
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.
5 freelancers are bidding on average £98 for this job
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