We need to convert an Excel file to a txt file. This Excel file will bring some data from an internal system that needs to be formatted into a txt file. After that, the txt file needs to be moved to a specific folder that will be accessed by FTP. All this process must be done automatically.
The txt header must follow:
- Date (dd/mm/yyyy) and time(hh:mm) mask Data separator (;)
- Decimal separator to measured values (,)
- Software ID that generated the file (ex: MIGRIS-4.5-U1-0041)
All IDs should appear in this order, without fail and preceded by the # character. The character * starts the header and character # closes the header (1st line) of the data file. An example of the data file header is shown below:
*#dd/mm/yyyy#hh:mm#;#,#MIGRIS-5.0-U1-0041#
The remaining lines in the file will be data rows only, whose formatting is Below:
- Date and time, separated by a space, in the respective formatting presented in the header;
- Data separator defined in the header;
- Tag that identifies the variable whose data will be entered (up to 20 alphanumeric characters, without spaces between each other, the control or special characters such as '*', '#', ';', '\', '/', ',', '.', '+', etc);
- Data separator defined in the header;
- Value of the data, whose decimal separator, if any, must correspond to that header (semicolon);
- Data separator defined in the header;
- Flag of the data, which normally identifies additional information linked to the validity of the (up to 2 alphanumeric characters);
- Data separator defined in the header;
- Data comment with up to 250 alphanumeric characters, not being accepted special or control characters;
- Data separator defined in the header;
Examples of data lines generated:
02/09/2003 07:30;IDAZRW_E03P11;0,00100000004749745;IS;calibration failure;
02/09/2003 08:30;E01P01;44,2999992370605;;;
02/09/2003 09:30;E01P01;80;;;
02/09/2003 10:30;E01P02;20,7000007629395;;;
*The Excel file will be generated hour by hour
All of this data will be exported in the excel file. So the job is:
Get the Excel file from a specific folder automatically.
- Convert the Excel file to a TXT file.
- Format the TXT file like as described.
- Create a routine to move the txt file to a specific folder automatically.
* We must have a way to set the folder in case we need to change it.
** The Excel file will be generated to a specific folder.
**** Every hour a new file will be generated.
Hello,
Hope you are doing well.
I can help with you in your project Automatically Convert an Excel File Data to TXT. I can assure you the quality job.
I have good experience in Data Entry, Data Processing, Excel, Visual Basic. We have worked on several similar projects before!
We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion.
I can assure the 100% job satisfaction.
Thanks,
Hi, there!
My name is Paris, and I was glad to see that you're looking for an Excel, and VBA developer. According to your brief, you want to have a macro that will format data and save it as a TXT file every hour.
I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed 268 projects successfully in less than six years, and I feel confident to complete your project as well. You're welcome to visit my page on this platform (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients.
I will charge you $140 and can deliver within five days (a single milestone to release once you're satisfied with the final result).
I'm online from 8 am to 9 pm, Athens time (including weekends).
I'm looking forward to working with you.
Sincerely,
Paris Pallas
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work.
Completed more than 250+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction.
I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
Hello?
How are you?
I have good experiences in "Automatically Convert an Excel File Data to TXT" as you can see my profile for these (Data Entry, Data Processing, Excel, Visual Basic).
I have been working for 7 yrs in this scope.
While we contract and work in our jobs, I will get paid once you have confirmed satisfied result.
If I do not deliver satisfied result, I will never get paid from you.
We can discuss more details to understand more easily if you have other infos.
Hope to work with you.
Thank you.
I am proficient with Microsoft excel and macro/VBA development, I can definitely write the macro to convert and save the data as depicted in your description. Would be great if you can provide a sample of your current excel sheet.
If you are interested feel free to message me, I am available to start your project immediately. Looking forward to chat further and work on your project.
Hi,
I'm interested to work in your task. I can implement the code in JAVA to automatically complete the Excel to Txt file with the file naming convention. I've done similar tasks.
Please contact me to start the task.
Thanks.
Rajesh
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months.
Willing to take up your project. Thank you, Regards.
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities.
“Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.”
Mohsan
Hi,
I have checked the description of the project in details and I will build this automated Excel sheet for you. I have finished many such projects of automated Excel data processing. I have 10+ years of experience of Excel, VBA macros and automation.
Please give me this opportunity to work on your project.
Thanks,
Mohan
Hello,
I am Excel and VBA expert.
I can do this project (VBA macro). I can start now.
If you have any questions, I will be happy to answer.
Please note that I have 100% completion rate and 5-star feedback on over 50 projects.
Jan
Hi,
I an expert in excel, VBA and Power bi. I can automate convert your excel file into a text file using power query in excel, power query will allow us to cleanse, sort, and format our data, and in VBA I will code to automate exporting data in text format.
Please send me your files with a clear specification, In less than 24 hrs, I will complete a sample part of the job before you award the project so you can be sure you’ve entrusted your job in the best hands. No commitments required!
Hope to hear from you soon
Sir,
I am well versed in these kind of jobs and can do your project as per requirement.
***I am ready to start
Waiting to hear from you.
with thanks and regards
Relevant Skills and Experience
Data entry, excel
hi, I can build a system tray application in vb.net to watch folder and process your excel to convert to txt file and move to processed folder, also I can upload to ftp folder if you want, send me a excel sample.
Hi,
My name is Virendra.
An Experienced Data Analyst and Macro Developer.
I have read your instructions carefully. Therefore, my proposal is specific for you needs.
I will create a macro to convert excel file into text file with specific format. Pickup excel file from specific folder and transfer text file into specific folder. All these processes will fully automated with single click.
I have excellent knowledge and experience of Manipulating Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports.
I have done mostly Excel VBA Programming job.
Please check my portfolio to see my work –
https://www.freelancer.com/u/vsprybhanu.html?page=portfolio
So, I can do this job nicely.
Ready to start, please message me to discuss your project in more details.
Thanks,
Virendra
I have 10 years experience with Data Processing in Excel and Web Researching. I work with:
Web Search
Web Scrapping
Excel
Access
PowerPoint
Statistics
Data Processing
Data Collecting (Using Macro)
MS Office
C++
HTML
VBA
Mathematics
Excel VBA
Macro
Automation
User Forms
Data Analyzing
PivotTable
Chart
Graphic Presentations
Photoshop
Data Presentations
And any task related to Excel
Feel free to contact me.
Hi
Nice to meet you.
I'm python expert and my last project on freelancer.com is also python scraping task.
My past works:
Youtube comment scrapping
Real estate property list to csv
Job-site content to csv
And scrap posts from facebook, twitter, instagram using scrapy.
I can build automation script.
I can help you related with python.
Let me know if you are interested in me.
Regards.
Hello, I hope you are well.
These are my strengths:
Immediate availability.
Responsible, fast and accurate.
Full-time freelancer.
Excel expert.
100% satisfaction guaranteed.
Available to any help after completion.
Experience of 7 years using excel for organizing and analyzing any company variables.
Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards.
Passionate about excel automation.
I'm an expert Windows application developer and can develop this application to convert Excel to TXT with the specified rules. I will develop the application using C++.
Delivery in : 4 days or less
Good quality work done. Thanks for considering my bid.
-Steve
Hi,
I am interested to work on this project. This would be great if you please consider my application. I will ensure on time delivery and 100% accuracy.
Thanks,
Moazzam