“Regex” type script to read/copy data and insert it into Excel spreadsheet
- or -
Post a project like this$$$
- Posted:
- Proposals: 2
- Remote
- #1525578
- Expired
Description
Experience Level: Expert
General information for the business: Read + data extract script
Description of requirements/functionality:
1. Script needs to reed data from CV files and copy contact details into a predefined Excel sheet
2. Number of files are stored in a given folder
3. Those files are Word/PDF format
4. File names are mostly represented in “firstname_lastname.***” format
5. The details to extract from CV files are
a. Firtsname
b. Lastname
c. Postcode
d. Mobile number
e. Email address
f. Graduation year
g. Degree name + University name
6. *Note* - each CV can be different and relevant contact details may be stored in Header/Footer of the document hence the script would probably need to convert all files into a more friendly format.
7. Script needs to be ‘smart’ enough to cater for many formatting scenarios
8. Some details will be easier to extract than others – like 1st name or email address.
9. I would like to automate it as much as possible and develop logic to copy as many details as possible
10. Needs to work on Mac (I am using standard MS Office package for Mac)
I will provide example input/output file.
OS requirements: Mac OS
Extra notes:
Description of requirements/functionality:
1. Script needs to reed data from CV files and copy contact details into a predefined Excel sheet
2. Number of files are stored in a given folder
3. Those files are Word/PDF format
4. File names are mostly represented in “firstname_lastname.***” format
5. The details to extract from CV files are
a. Firtsname
b. Lastname
c. Postcode
d. Mobile number
e. Email address
f. Graduation year
g. Degree name + University name
6. *Note* - each CV can be different and relevant contact details may be stored in Header/Footer of the document hence the script would probably need to convert all files into a more friendly format.
7. Script needs to be ‘smart’ enough to cater for many formatting scenarios
8. Some details will be easier to extract than others – like 1st name or email address.
9. I would like to automate it as much as possible and develop logic to copy as many details as possible
10. Needs to work on Mac (I am using standard MS Office package for Mac)
I will provide example input/output file.
OS requirements: Mac OS
Extra notes:
Michal F.
97% (6)Projects Completed
6
Freelancers worked with
6
Projects awarded
33%
Last project
27 Jul 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Michal,
would a Python script be good for you? Are you comfortable running Python scripts?
Thank you,
LucyMichal F.06 Apr 2017Hi Lucy,
Yes anything that does the job correctly will do.
Thank you,
Michal -
Hello Michael,
could you please provide the sample input / output files as mentioned?
Thank you
PetrMichal F.06 Apr 2017Hello Petr,
Please see the files attached. -
how many CV you have?
Michal F.06 Apr 2017The number is irrelevant. The script must be repeatable (with a manualy specified input folder - the folder name will change as dates move on e.g. CV_06042017 etc.). One time it will be 100 CVs the next day it will be 200 CVs.
allpoo.com06 Apr 2017Thanks for reply.
could you please provide 2 or 3 sample CV and output file?
382504381978381968
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies