Import a text file and format the data into a google sheet.

Completado Publicado hace 2 años Pagado a la entrega
Completado Pagado a la entrega

Requirements for text file Processing

1) Given a text file formatted in a consistent fashion as in the file provided.

2) Import the data from the text file provided by the vendor and display it in a spreadsheet.

3) The data shall be organized into a table that puts the PO Number, Order Number, Ship Number, Item, Status Number, Lot Number, TRM, Date, and Update all into a row as shown below.

4)Each line shall be a different cell.

PO #

Order #

Ship #

Item #

Status #

Lot #

TRM

Date

Update

5) Each table shall contain the contents of the entire text file including the header information, but the header information may be displayed in any easy to read format at the top of the spreadsheet.

6) Each PO# Line represents one forklift and the total number of forklift trucks shall be counted and displayed in the header information along with the upload date.

7) A new tab shall be created every time that a new text file is processed.

8) The name of the tab shall be the date listed in the header of the text file.

Procesamiento de datos JavaScript Google Apps Scripts Google Sheets

Nº del proyecto: #33421224

Sobre el proyecto

28 propuestas Proyecto remoto Activo hace 2 años

Adjudicado a:

(392 comentarios)
7.7

28 freelancers están ofertando un promedio de $157 por este trabajo

nimiwebjuggler

Hi, I'm an Expert Virtual Assistant providing services of Data Entry, Web Research, Data Mining, Data Processing, PDF conversion, Microsoft Office work, Photoshop work, and much more! I have experience of more than 2 y Más

$140 USD en 1 día
(102 comentarios)
6.5
WebInfoSolutions

I would like to see sample excel format for import. In order to make excel, I need a window server. Can you provide that?

$250 USD en 2 días
(41 comentarios)
5.2
RajulRao

Hello! It's Rajul, An Experienced Software Developer. I am ready to work with you, I have read your details and requirements and I am highly confident that I will deliver you the task. I am an expert coder with skills Más

$200 USD en 5 días
(1 comentario)
3.2
mayankupadhyay

Interested, having 9+ years of experience in development Good thing is that I know all tech that is required in your project to go Ping me to get start it now

$80 USD en 7 días
(10 comentarios)
3.1
danielbotnik

Hey, I have five years of softwere development, about three of them in python. I have used Goole Sheet API before, so I know how to use it, I've also looked inside the attached file, and I can gurraente I can parse the Más

$130 USD en 7 días
(2 comentarios)
1.9
GhufranAli1

Hello, Thank you for posting your job opening for Data Entry. I have two years of data entry experience, and I have performed all of the duties listed in your job description. I have excellent typing speed and data ent Más

$30 USD en 1 día
(5 comentarios)
1.5
deductivedesign1

Hello dear! I am available now to discuss the project! I am experienced Graphic Designer and I use CorelDRAW & Adobe Photoshop with skills including Google Sheets, Data Processing, Google Apps Scripts and JavaScript. Más

$75 USD en 1 día
(0 comentarios)
0.0
mbutt87

✔️ Hi Sir, I gone through your project description and I am confident to deliver what you are looking for. However to move further I need some details from your end. ✔️ Kindly message me Thanks. Regards, Mahwi Más

$250 USD en 5 días
(0 comentarios)
0.0
potleprerana2002

I will do my best so hire me for your work i make sure that will do my best in your work thats it i want this job

$140 USD en 7 días
(0 comentarios)
0.0
vitaliynetreb

hello there I am senior front-end development with over 5+years. So I have rich experience in PHP, Website&graphic Design, and so on. Also, I have some good idea about your project. looking forward to hearing from yo Más

$250 USD en 10 días
(0 comentarios)
0.0