I Need a linux shell script (Perl/Python) to do the following
1.) Read Data from a XLS spread sheet or CSV
2.) create text file following format [login to view URL]
The following are the headers of the .XLS/CSV file
*** Please note the location of the headers may or may not be exact same every list ***
application date,requested_amount,first_name,last_name,birth_date,sin,email,home_phone,work_phone,cell_phone,address,city,province,postcode,address_length_months,own_home,income_type,employer,job_title,employed_months,monthly_income,pay_frequency,bank_institution_number,bank_name,bank_branch_number,bank_account_length_months,bank account number,direct_deposit,bank_account_type,title,employer_address,employer_city,employer_province,employer_postcode
i want the output to look like the following
Application: application date
Ammount: requested_amount
Name: tittle first_name last_name
SIN: sin
DOB: birth_date
Address: address
city, province
postcode
Phone: home_phone
Mobile: cell_phone
work: work_phone
E-Mail: email
Res Type: own_home
Residence: address_length_months
Status: income_type
Employer: employer
Tittle: job_tittle
Address: employer_address
employer_city, employer_province
employer_postcode
Length: employed_months
Income: monthly_income
Paid: pay_frequency
Bank: Bank_name
Institution: bank_institution
Transit: bank_branch_number
Account: bank account number
Account Type: bank_account_type
Account Age: Bank_account_length_months
Hi , I am a python expert and I have very great expertise on data handling and in python. Also I primarily work on linux too.I can do this work for you within an hour or so
$120 CAD w 1 dzień
5,0 (4 opinii)
4,5
4,5
9 freelancerzy składają oferty o średniej wysokości $196 CAD dla tej pracy
Dear sir,
I have done many projects in shell script and got some positive feedback from clients. You can check my profile for more information. Let me help you. I'm ready to get started right now.
Thanks and best regards,
Tinh Nguyen
I am very proficient in perl, I use it extensively for similar tasks and that is what I would propose doing this task in. Reading data from the XLS spreadsheet would provide a bit more of a challenge than a .csv, are you proposing that the script do either? If so would it be acceptable to install a perl module?
Otherwise I think it would be prudent to provide a dummy file to ensure that the formatting is exact and you are getting what you want.
Feel free to contact me for further details