
Query & report on CSV data
- or -
Post a project like this2012
£14(approx. $19)
- Posted:
- Proposals: 15
- Remote
- #2883865
- Awarded
Graphic Designer |Experienced Web Designer | Video/Audio Editor | PowerPoint/Keynote | Content Writer |

3915857343141638734912627754506664304612656985440683635147041170933652753821961
Description
Experience Level: Entry
have a large csv files with address, post code and name fields ( sample attached) . the total file size is about 3.5TB
I want to be able to cross reference a list of post codes (csv format).
So let's say that i have one postcode or a list of postcodes. I want to be able to put this list of postcodes somewhere in the xls or exe or vba or whatever, and return every row in the original worksheet form which contains that / those postcodes.
As an example lets say in the sample file attached i wanted it to search for these postcodes:
CF11 8EY
CF15 7SR
CF24 4BG
CF3 0AA
CF3 0AB
CF3 0AD
CF3 0AE
CF3 0AF
CF3 0AG
CF3 0AH
CF3 0AJ
CF3 0AL
CF3 0AN
Then i want to the result to be all rows that have those postcodes from the above list in. ( i will then use that resulting data to print address labels.) So i might end up with a 500 rows or results . I want to then save this as a new workbook.
This is exactly the same as if I were using the sort/filter button on the " postcode" column, and was manually selecting the postcodes, which would return all the results I want. I just don't want to do manually as there could be hundreds!
I have done a short video that shows you how i would have to do this manually. I just want to automate this process. I MUST be able to just start with a list of postcodes. Video can be viewed here: https://www.dropbox.com/s/opvfw645pc3j72s/PPH%20example%20.mp4?dl=0
I am not looking to pay an hourly rate - I want to pay a flat fee for the job. If you want to apply please send me your proposal with your total fee.
Thank you for your consideration.
I want to be able to cross reference a list of post codes (csv format).
So let's say that i have one postcode or a list of postcodes. I want to be able to put this list of postcodes somewhere in the xls or exe or vba or whatever, and return every row in the original worksheet form which contains that / those postcodes.
As an example lets say in the sample file attached i wanted it to search for these postcodes:
CF11 8EY
CF15 7SR
CF24 4BG
CF3 0AA
CF3 0AB
CF3 0AD
CF3 0AE
CF3 0AF
CF3 0AG
CF3 0AH
CF3 0AJ
CF3 0AL
CF3 0AN
Then i want to the result to be all rows that have those postcodes from the above list in. ( i will then use that resulting data to print address labels.) So i might end up with a 500 rows or results . I want to then save this as a new workbook.
This is exactly the same as if I were using the sort/filter button on the " postcode" column, and was manually selecting the postcodes, which would return all the results I want. I just don't want to do manually as there could be hundreds!
I have done a short video that shows you how i would have to do this manually. I just want to automate this process. I MUST be able to just start with a list of postcodes. Video can be viewed here: https://www.dropbox.com/s/opvfw645pc3j72s/PPH%20example%20.mp4?dl=0
I am not looking to pay an hourly rate - I want to pay a flat fee for the job. If you want to apply please send me your proposal with your total fee.
Thank you for your consideration.
Justine T.
100% (19)Projects Completed
18
Freelancers worked with
17
Projects awarded
41%
Last project
4 Nov 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-

Hi Justine. Can you confirm that the file is 3.5TB. That is a very large file and a lot of addresses.
-

Hi Justine, you mentioned "sample attached" but the job doesn't contain any attachment. Would you be able to attach the sample?
927472926812
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