I need a web scraper written for the .xlsm file in the following directory:
[login to view URL]
The latest .xlsm file within that directory will need to be downloaded.
The name of the file is subject to change daily and will need to be identified by the latest .xlsm extension.
The output should be a pipe (|) delimited file with the following column mappings:
origin_city --> data located in column (A)
origin_state --> data located in column (B)
ship_date --> data located in column (G), change to the YYYY-MM-DD format
if the date is old, use the current days date changed to the YYYY-MM-DD format
destination_city --> data located in column (C)
destination_state --> data located in column (D)
receive_date --> leave blank
trailer_type --> data located in column (E)
load_size --> if data in column (F) contains "Truckload" add the text "Full",
if data in column (F) contains "LTL" add the text "Partial"
weight --> data located in column (M), if column contains (blank), leave blank
length --> leave blank
width --> leave blank
height --> leave blank
trip_miles --> leave blank
pay_rate --> data located in column (I), if no data leave blank
contact_phone --> data located in column (N)
contact_name --> leave blank
tarp_required --> leave blank
comment --> data located in column (O), also add data located in columns (J),(K),(L)
with the first letter of the column headers before the data (ie L40-0, W8-0, H8-6)
load_number --> leave blank
commodity --> leave blank
The first line of the output should contain all of the column headers.
Any field that contains no data should be left blank.
Please do not use words like "null" or "blank" in blank columns.
Below is a sample output of the first 5 columns using sample data:
The deliverable will be a Perl .pl file that must run on
Ubuntu Linux and must use Modern::Perl. The Perl .pl file
should be called '[login to view URL]' and the output file should be
called '[login to view URL]'
It will be scheduled in cron to run unattended every 15 minutes.
Please specific what language/OS/modules you plan to use.
Also, please include the word "raccoon" in your bid so I know that
you read this description.
16 freelancers are bidding on average $113 for this job
hi, raccoon 1) I have read your project and can make you this script. 2) I will make this script in PYTHON. 3) The script will do all the steps defined in the description. I would love to talk further in chat.
raccoon, Hi, I would like to complete this script in python, In one day. I have around 5 years of working experience on web scrapping tools, like nutch and scrapy, If you want to see demo please put a message.