Simple Excel (CSV) Filter Project
$10-30 USD
Pagado a la entrega
Should only take a few hours, if that to complete.
User will upload a CSV file with the following columns:
Unique ID, Parent First Name, Parent Last Name, Parent E-Mail Address, First Name, Last Name, Number of Visits, Date of Last Visit and Visit Dates
Immediate export of same file except that code will analyze csv file based on:
- Each unique ID and find the number of days between date of last visit and most recent visit prior to that and add that number in an additional column labeled Days Between Most Recent and Last
Then it will purge all duplicate rows for that unique ID and leave just one row for that unique ID that has the most recent Visit Date in it.
To give you an example of the process, the first file shows what the file would look like when uploaded.
The second image shows you what data to look for, first the unique ID, second the most recent visit date and third the most recent Previous visit date.
The third file shows you the end result of what the file should look like. You'll see all the extra lines have been purged leaving a clean file with only one of the unique ID's for each customer, the row that is left is based on the Visit Dates column and it is the date that is PREVIOUS to the MOST RECENT (or what is in the Date of Last Visit column). You'll also see it appended the number of days between PREVIOUS most recent date and Date of Last visit date.
You do not have to save anything to database if you don't want to, you don't have to save files to server, you don't have to change any columns around, or have logins or users accounts, literally is just an upload and download project.
It must be able to handle a lot of records, must be able to do calculation. Only one file will be uploaded/processed at a time so no need for batch uploading, etc.
Nº del proyecto: #17920312
Sobre el proyecto
Adjudicado a:
Hello there. I can create a php script to filter the CSV file as per the details mentioned. Please send me a message to get started. Thanks
33 freelancers están ofertando un promedio de $33 por este trabajo
This is Vibrant Webtech and I was glad to see that you're looking for help for project Simple Excel (CSV) Filter Project. I've delivered more than 400 + projects in the last 5 years and this makes me very confident w Más
Hello? How are you? I have good skills in this type jobs..... So I can complete your job in time. Hope to work with you. Thank you.
Hello sir, I have reviewed the attached images for before and after dta processing, I can do it as per your requirements and I can deliver it within 24 hours max. Thanks
Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportu Más
I have gone through the 3 attached images and have got the idea. 1- Please provide sample CSV file . 2- I will make an executable having a browse file and Start process button. Upon clicking button it Más
Hi there, I'm expert in Advance Excel, Formula and Function. I've analytical ability to make report. Please check my profile as I've similar job experience. I'm ready to start immediately. Waiting for your Más
Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.
"Hello, I am happy to inform you that I have read your project ""Simple Excel (CSV) Filter Project "" description and understood all of your required requirement. I'd like to help you with confidence and satisfying Más
hi next employer, I am interested in your project. I hold master degrèe in finance. Having more than 9 years experience of data entry, web scraping, excel based projects. hope you give a chance to work with you
About me & what I can provide - • I understand that you want only one row in data after processing and the row should have visit JUST BEFORE the last visit • 5 Yrs. of Experience in Excel & VBA. • Knowledge of Form Más
i am Data Entry. Data processing expert who knows the value of time, very hard working and always delivers the work on time .my motive is to make my employer happy without adding additional charges. If you are looking Más
Dear sir, I can meet your requirement through a excel vba development.i have developed many excel solutions as well. Thank you
Hello Dear. I am a Professional Virtual Assistant & Lead Generator Expert. i saw you job Description. it is very nice. I saw your samples beautifully. I can do your work within 2-3 hours. You can hire me if Más
Hi, I can provide you this within a day. Please let me know if you are interested. I will create PHP application to handle all this.
Hello, I plan on using MS Excel formulas to calculate the days between the dates and after calculation is done, then it removes the duplicates.
Hello, I am expert in excel, data processing can help you in what you need quickly and with high quality Many thanks, Hoda
I have very good typing speed with accuracy. Know the value of time too. Have experience in data entry, email handling, chat support. worked with telecommunication company as a project specialist.