Suoritettu

Sort a large file -- 2

I have a file of 28 million business listings (records) that just needs to be SORTED by SIC code. It's currently broken down into 50 excel files and needs to be combined, Sorted then broken down into 50ish excel files (which have to be less than a million records each).

I'm not picking someone I'm just paying the first person that completes it.

Here's the file:

[login to view URL]

Here's how it has to be sorted:

It has to be sorted by SIC2, secondary sort by SIC4, additional secondary sort SIC8, (see attached image) and then broken up into chucks of 1 million records or less again so it can be opened in excel.

The payment/fee is $25 and I'll award and pay the FIRST person that completes it. I will close the project after wards. I spent days waiting for various different people that all said they could do it and then didn't and just want to get it done.

Taidot: Tietojenkäsittely, Excel

Näytä lisää: insert large file access, sort text file, large file upload process progress bar php, program sort excel file, send large file pictures thumbnails, sugarcrm import large file, quick sort large text file, large file sort, fix audio blown up by microphone I have a few audio file example attached is the worst, others are less problematic, c# sort large text file, sort large text file windows, python sort large csv file, magento 2 unable to resolve the source file for, magento 2 unable to resolve the source file for css, python sort large file, the file is not displayed in the editor because it is too large

Tietoa työnantajasta:
( 6 arvostelua ) Salt Point, United States

Projektin tunnus: #28959635

Myönnetty käyttäjälle:

Yourn1freelancer

Hello, I have produced the files you need. Please get in touch if you want to check the files. Cheers, G.

$25 USD 1 päivässä
(5 Arvostelua)
4.2

12 freelanceria on tarjonnut keskimäärin $25 tähän työhön

MMG2019

Hi, I can build small tool in Visual Basic to sort all your Excel files. I can start now so, i need confirmation from you to start working. Feel free to discuss. Thank you

$50 USD 1 päivässä
(23 arvostelua)
4.5
lisamarlen168

I am very excited for this task. I will do this job accurately. Send me a message for further discussion. Thanks

$20 USD 1 päivässä
(23 arvostelua)
4.1
Innolawrence

Hi. Sorry for the disappointment, but i promise i won't disappoint you. I understand your standpoint, i would have loved to complete the task first then get hired but the file is too large to download, 1.9GB. May you c Lisää

$25 USD 2 päivässä
(14 arvostelua)
3.8
Vamsi4113

I can perfectly help you with that. I am a professional and bid only on the tasks which I can complete. I have done similar tasks before. But considering the data size complexity here, I request you to award the projec Lisää

$25 USD 1 päivässä
(4 arvostelua)
2.6
khaldalfalah

I will work to perform your project then know you when i finish. I have experience in VB.net, MS SQL server, asp.net and crystal reports more than 13 years. Other skills: Access vba, Excel vba, C#, my sql , technica Lisää

$25 USD 2 päivässä
(3 arvostelua)
1.8
GovindaHorejonba

Dear sir, I am interested in this project. I talk to you about this project. i am a new member of this platform but I am doing many projects in my day to day work life. so I do your project properly.

$18 USD 3 päivässä
(0 arvostelua)
0.0
jenny970

Hi,am jenny I am really interested for your [login to view URL] can trust me and I hope i will do this job perfectly. Send a message then we can disscuss more for your project. Thanks, Jenny

$20 USD 1 päivässä
(0 arvostelua)
0.0
keysc02

i would be happy to be at your service, I've check the Dropbox link so I could start doing the report but file was too big. I could make this report in 3 days, it would be great if you could give me other links. Plea Lisää

$20 USD 3 päivässä
(0 arvostelua)
0.0
JGLconsulting

Hi there! We are currently working on your request and have combined and sorted the files as of the moment. Currently splitting it to multiple excel/csv file. Once done, How do we forward the files? Thanks JGL

$25 USD 7 päivässä
(0 arvostelua)
0.0
kimsyikin

Dear Employer, I understand your worries, but I am confident. I can take up this job and do it with perfection. It may take a few days due to our different time zone. Please feel free to contact me as soon as possib Lisää

$25 USD 3 päivässä
(0 arvostelua)
0.0
Sadav

Hello, I already had the job done. After some tries and mistakes, I figured out how to process it in a few time (about one and a half hour). The whole numbers of records are 28,858,789, and I split it into 29 files. Be Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0