Completed

Script or converter to rearange and strip some columns from excel file and convert to csv txt

We have an excel document that we use to keep track of ongoing orders. Our customer requires that we send a comma separated text file over to them on a daily basis so they can keep up to date on the status of the orders as well. There are some columns in the excel file that we maintain that we would not want our customer to see. For a time we were maintaining two separate excel documents but that resulted in doubling the amount of work that we do.

We would like to take our existing excel file and be able to “convert it” to the format the customer needs, rearranging and stripping some columns. When it is “converted” some of the columns will need to be moved around and reformatted. The date needs to be switched from mm/dd/yyyy to yyymmdd for example. We want to keep the existing excel file intact but then create a new file as a comma separated .txt file and have a name of pl<mmmddyyy>.txt.

Refer to fig1 for a sample of what our excel file looks like that we maintain.

Refer to fig2 for the requirements for the output.

Skills: Data Processing, Excel, PHP, Software Architecture, Visual Basic

See more: excel export selected columns to csv, excel export column to text file, excel export selected rows to csv, how to open csv file in excel, convert rds to csv, excel export single column to csv, export range of cells to csv, how to export selected rows in excel, 360-degree video work new caledonia, 2d animation work new zealand, 2d animation work new caledonia, .net work new zealand, .net work new caledonia, For unity3d project work new, web developer disclaimer new create site, need web developer home work new zealand, freelance work new zealand, freelance work new york indesign, new create logo, excel file convert

About the Employer:
( 2 reviews ) Council Bluffs, United States

Project ID: #16613288

Awarded to:

arranmercer

Hello from across the pond! I can create a VBA macro which will move the data, delete columns, manipulate the dates from a date format into the required YYYMMDD format and then export as a .txt (comma delimited) wit More

$60 USD in 1 day
(11 Reviews)
4.1

14 freelancers are bidding on average $75 for this job

rajeshsonisl

Hi there, I do not see columns from the output in the input file, eg: Factory Order Number, Dealer Number. What are the field mappings (input => Output) ? I have a 99% project completion rate and a 4.99 reputation More

$94 USD in 1 day
(897 Reviews)
8.5
uhjk

Hello, I can create php script to convert excel to csv based on screenshots you provided. I can deliver you script in 24 hours. If you don't have hosting, you can use my hosting no problem. You will upload .xls file an More

$80 USD in 1 day
(649 Reviews)
8.1
gatsu58

Hello, I am excel expert, it should be easy for me, but can you explain a bit about the start point and length. Regards, Santos

$30 USD in 1 day
(184 Reviews)
6.1
sstevan

Hello, Can you please send me example files (I need to see exact format) and I will get you back demo script in Python. If it works as it should, you can award me for the project. Feel free to check my profile. More

$110 USD in 1 day
(12 Reviews)
5.8
Piao217

Hi, I read your post with interest and we can handle it. My team has developed many Windows desktop applications in various fields including Office Automation. Especially we have a very rich experience in business s More

$155 USD in 3 days
(18 Reviews)
5.9
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo More

$35 USD in 1 day
(28 Reviews)
4.3
hsingla85

Available Immediately | MS Excel Expert | MBA | Assured accuracy and minimum turnaround time | Have done the transformation job successfully. please see my jobs history

$88 USD in 3 days
(4 Reviews)
2.7
BeyoutiF00L

We write and design with our heart, and edit without it. The content and Design plays a very important role in deciding, whether a visitor, will bounce off, or return as a customer. Each word that we putin text is espe More

$30 USD in 2 days
(4 Reviews)
1.5
mowachira77

Good morning/ afternoon. I am Excel expert. I have read through your proposal and checked the images you sent along. I am sure and confident I can format the data as per your requirement. Feel free to reach me via chat More

$55 USD in 1 day
(0 Reviews)
0.0
Arsgoet1a

I have extensive knowledge and experience in data management and automation. I can also take care of performing a QA protocol that will ensure the data is consistent in format and category.

$111 USD in 3 days
(0 Reviews)
0.0
kumartech81

I have very good experience in converting Excel file. I can provide you a command line tool. it takes the desire excel input file and convert it into expected out file. The conversion will be implemented in Java More

$45 USD in 2 days
(0 Reviews)
0.0
healthmonkey

Hey, my name is Philipp and I am a statistical programmer and data scientist. My roots are in quantitative finance, but ever since I became a freelancer I work on all kinds of data related jobs such as yours adverti More

$100 USD in 1 day
(0 Reviews)
0.0
vishvachakure

I do have a expertise in excel data mining with Excel VBA/Macro and Vbscript. Can provide you Vbscript + html offline page for this project. It will be simple and easy to use. Can show you the demo work which i don More

$55 USD in 1 day
(0 Reviews)
0.0