En cours

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 ([url removed, login to view] rows) each one.

- For example, if the Text File has [url removed, login to view] lines, I will expect 7 Excel files with 200k each one, except the last one which will have [url removed, login to view] 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, Traitement de Données, Administration de Bases de données, Programmation de bases de données, Excel

Voir plus : writing task one, text string, hire someone excel, file expect, expect file, convert excel files, convert excel files vb6

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

N° du projet : #8522347

Décerné à :

rohitagarberg

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

20 $ USD en 1 jour
(54 Commentaires)
4.4

55 freelance ont fait 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) List_Of_IDs.xlsx is for reference only? Plus

34 $ USD en 1 jour
(46 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

35 $ USD en 1 jour
(81 Commentaires)
5.9
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

25 $ USD en 0 jours
(59 Commentaires)
5.4
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

35 $ USD en 0 jours
(114 Commentaires)
5.5
faheems189

"TXT to XLSX" Hello sir, i can complete this work in next 2 hours maximum.kindly pm me, i have saample ready for attached "output.txt " Thanks.

35 $ USD en 0 jours
(44 Commentaires)
5.4
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

30 $ USD en 0 jours
(83 Commentaires)
5.5
gatsu58

TXT to XLSX Hello, I can complete the project within 2 hours I have a question: The output.txt have 8 column, and the Structure_Needed.xlsx have 7 column. Regards, Jay

35 $ USD en 0 jours
(63 Commentaires)
5.0
deepabittu

A proposal has not yet been provided

35 $ USD en 0 jours
(77 Commentaires)
5.5
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

27 $ USD en 1 jour
(92 Commentaires)
5.1
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

24 $ USD en 0 jours
(56 Commentaires)
5.1
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

25 $ USD en 0 jours
(35 Commentaires)
4.8
zebracaro

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

30 $ USD en 1 jour
(39 Commentaires)
4.4
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

35 $ USD en 1 jour
(2 Commentaires)
4.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

35 $ USD en 1 jour
(20 Commentaires)
4.1
CristianRam

TXT to XLSX | I can comfortably complete all your tasks within 2 hours, but I need clarification on the final point about restaurant ID. It looks like output already has the fields "restaurant number" and "restaurant Plus

35 $ USD en 0 jours
(4 Commentaires)
3.4
wissamSabry

I am an advanced user with over 10 years of MS Office experience. As A Microsoft Certified System Administrator I am Excellent in word editing, processing , spread sheets I can very quickly help you with any Microsoft Plus

40 $ USD en 1 jour
(7 Commentaires)
3.5
sayli2

"TXT to XLSX" ------------------------ I AM HUMAN :) ---------------------------- I am programmer/developer. Expert in Excel/Macro. I will write program for you in C# that convert your text file into excel. Maximu Plus

29 $ USD en 2 jours
(25 Commentaires)
3.6
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

35 $ USD en 1 jour
(14 Commentaires)
3.5
SashaPinsk

TXT to XLSX Dear customer, I am a .net developer with 2+ production experience. I will complete this task in 2 hours. Happy to inform you that almost whole last week I have dealt with programming excel with O Plus

35 $ USD en 1 jour
(1 Commentaire)
3.2
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

35 $ USD en 1 jour
(6 Commentaires)
3.2