Terminé

Convert One Text File to Many Excel Files

Hi people, how is it going all?

Start your BID writing: "TXT to XLSX" to know you are not a bot. I'll filter bids reading this.

I need a fast turnaround this time.

I'll hire someone who has the right skills (and experience) for next tasks:

- Convert one Text File to Excel format (the Excel files need to have at the most, 200K rows (200.000 rows) each one.

- For example, if the Text File has 1.345.000 lines, I will expect 7 Excel files with 200k each one, except the last one which will have 145.000 rows.

- Check the file "[url removed, login to view]" to see how the Text File will be presented. This attached file is just a sample with few lines inside. The right candidate will receive the complete file then.

- You can get the Excel attached here, called "[url removed, login to view]" to know how should be presented each Excel file. The Text File has fields separated by "|" (pipe).

- Please, trim all empty spaces to the left (start of the string) and to the right (end of the string) of each field before to generate the excel files.

- Finally, get the file attached here, called "[url removed, login to view]" and do a simple join using first column ID and update the corresponding column in the Excel files (you should do this before to convert it to Excel, guess is better for you). Ask me for this point to be sure you can do it.

I will expect this task completed today, in no more than 2 hours of time (if you know what you are doing). It is simple task, just many data to manipulate.

** My MAX Budget is $ 35. **

Thanks, and good luck for everyone.

Compétences : Big Data Sales, Traitement de Données, Administration de Bases de données, Programmation de bases de données, Excel

en voir plus : writing task one, text to string, how to hire the right people, hire someone to do excel, file expect, expect file, convert word table excel files, large excel files access file, convert audio files mp3 file, convert excel files stand alone program, convert photoshop files html file, excel file program text file, convert pdf files fillable file, Convert Excel files, convert excel files vb6, convert dat files excel files

Concernant l'employeur :
( 62 commentaires ) La Plata, Argentina

Nº du projet : #8522347

Décerné à:

rohitagarberg

placed the bid. thanks...............................................................................................................

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(244 Commentaires)
6.0

55 freelance font une offre moyenne de $29 pour ce travail

Beacon09

Hi I have read the description carefully. 1) I would like to know how 1.345.000 lines will result in 7 excel files if each has 200K rows? Isn't the calculation wrong? 2) [login to view URL] is for reference only? Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(71 Commentaires)
6.6
deepabittu

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(206 Commentaires)
6.4
dpune

TXT to XLSX Hi, Do you need a program to do multiple time or is it only one time task ? I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 250 proj Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(132 Commentaires)
6.3
MohsanEijaz

TXT to XLSX I think I am a good fit for this job because I have all the qualities that you are looking for. Experience is the golden factor in this project where you find in me at least 3+ years of working experienc Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(63 Commentaires)
5.9
zebracaro

i can do it for you quickly and exactly. Please contact me!!!

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(84 Commentaires)
6.1
Attractionnet

TXT to XLSX Hello. I have created many programs like this one. I will create a small application in vb.net which will import,split and export the files the proper way. I can start asap. You can reach me via ch Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(98 Commentaires)
5.9
fatimatuzzohura

"TXT to XLSX" Hi, I have read the project and understand your requirement. I definitely have some questions when we discuss project with you I am very much interested and have experience to do manual/ automated i Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(116 Commentaires)
6.0
gokulanand

TXT to XLSX Hello, I can get you the task done in the next 2 hours using a macro. Let me know if you are interested. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(101 Commentaires)
6.0
gangabass

TXT to XLSX I need less than a hour to create the program you want. All I need to know is what OS you will run it. I can create Windows, Mac or Linux executable. Thanks. Roman

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(137 Commentaires)
6.1
RRajeshR

"TXT to XLSX" Hi, I can complete your task as per your requirement. I would like to have a clarification on the requirement: 1. The sample text file provided has 8 field, but the structure needed has only 7. Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(39 Commentaires)
6.0
expertatwork

TXT to XLSX... Hey there...we carefully studies both text and excel files and we understood how data is mappped and extracted...we can do this with 100% accuracy...please reply..we can discuss further..hopefully, we ca Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(153 Commentaires)
5.9
gatsu58

TXT to XLSX Hello, I can complete the project within 2 hours I have a question: The [login to view URL] have 8 column, and the [login to view URL] have 7 column. Regards, Jay

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(101 Commentaires)
5.5
catstevens2009

TXT to XLSX ================ Hi there! Have done this type of work before, and am an Excel expert doing quick, quality and accurate Excel work! Please feel free to message me with additional information or with que Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(84 Commentaires)
5.7
faheems189

"TXT to XLSX" Hello sir, i can complete this work in next 2 hours [login to view URL] pm me, i have saample ready for attached "[login to view URL] " Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(86 Commentaires)
6.0
dviruki

Jorge, hi! I looked through the files and it's something I can do quite fast. I'm available at the moment, so please let me know if you still need help with this project. Regards, Roman

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(65 Commentaires)
5.4
adityasl

TXT to XLSX Hello, I am interested in the project. I have converted the sample text file in excel. I will like to show before confirming. I have Excel 2003 which supports 65k rows only. What is the size of Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(121 Commentaires)
5.3
mdkass

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(13 Commentaires)
4.7
serdaryalcin

TXT TO XLSX Hi I have completed some projects like the one mentioned. Millions of records were read and arranged more or less as you required. Will you share the file and ask for the result XLSX files, or do Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(21 Commentaires)
4.5
slenders13

TXT to XLSX Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(16 Commentaires)
4.5
Rakibhasannur

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(24 Commentaires)
4.1