Find Jobs
Hire Freelancers

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

$30-250 USD

Fullført
Lagt ut omtrent 6 år siden

$30-250 USD

Betalt ved levering
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.
Prosjekt-ID: 16613288

Om prosjektet

13 forslag
Eksternt prosjekt
Aktiv 6 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
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) with pl<mmmddyy>.txt as the file name. I work full time as a Data Analyst and I use VBA every day for similar tasks, so i'm very accustomed to this kind of work. Please let me know if you have any questions. Thanks, Arran
$60 USD om 1 dag
5,0 (13 omtaler)
4,1
4,1
13 frilansere byr i gjennomsnitt $69 USD for denne jobben
Brukeravatar
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 (out of max 5.0 from more than 1100 projects over 11 years. Thanks. I look forward to hearing from you Regards, Rajesh Soni.
$94 USD om 1 dag
5,0 (984 omtaler)
8,7
8,7
Brukeravatar
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 and download .csv file online.
$80 USD om 1 dag
5,0 (898 omtaler)
8,3
8,3
Brukeravatar
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 om 1 dag
5,0 (189 omtaler)
6,4
6,4
Brukeravatar
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. Thanks, Stevan
$110 USD om 1 dag
5,0 (12 omtaler)
5,8
5,8
Brukeravatar
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, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
$35 USD om 1 dag
4,7 (31 omtaler)
4,5
4,5
Brukeravatar
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.
$55 USD om 1 dag
4,7 (11 omtaler)
3,4
3,4
Brukeravatar
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 advertised. I am very experienced in Excel and VBA and will be able to help you creating the new txt files for your customer. Given the pictures, I have a rough understanding of what needs to be done, but I would prefer to take a look at the real files in order to see how the data relates. Anyways, I would suggest a VBA solution, which will run automatically after a button is clicked. Then the files are automatically created and saved in a specific directory or could also be sent out automatically - just as you desire. I am open to what ever you require for this job. Please contact me to discuss the details of this jobs, such as deadlines etc. Thanks. Philipp
$100 USD om 1 dag
5,0 (2 omtaler)
3,3
3,3
Brukeravatar
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 om 3 dager
5,0 (8 omtaler)
3,4
3,4
Brukeravatar
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 especially curated, keeping in mind the brand identity, and the aura of the product,which makes it attractive and difficult to forget.
$30 USD om 2 dager
5,0 (4 omtaler)
1,5
1,5
Brukeravatar
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 om 3 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
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.
$45 USD om 2 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
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 done in past for my clients.
$55 USD om 1 dag
0,0 (0 omtaler)
0,0
0,0

Om klienten

UNITED STATESs flagg
Council Bluffs, United States
5,0
10
Betalingsmetode bekreftet
Medlem siden jul. 11, 2014

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.