Find Jobs
Hire Freelancers

Basic CSV\Tab delimited data processing tool - w/ examples

$30-250 USD

Completed
Posted over 12 years ago

$30-250 USD

Paid on delivery
The purpose of this tool is to replace text within a tab delimited file by identifying matching text in a csv file. I’ve provided 2 example files. The first file [login to view URL] has a list of electronic transactions. The second file [login to view URL] has another list of transactions. The tools purpose is to simply match up the field “Item ID” in [login to view URL] and [login to view URL] and copy the “Custom Label” field from [login to view URL] into [login to view URL] over the “Item Title” field. The resulting file is transactions – [login to view URL] All “Item Titles” that have not been replaced in [login to view URL] which have no “Item ID” match in [login to view URL] need to be grouped together (identical item IDs that have not been replaced should be handled in the background so the new title is applied to all “Item Titles” with the same “Item ID”) and displayed with the “Item ID” “Item Title” & “Net” (the price and item title). The “Item Title” field should be able to be modified. When updated and “save to file” button is selected, the new “Item Title” on the remaining transactions will be copied to the corresponding “Item Title” fields (based on “Item ID”) in [login to view URL] The files provided have had personal information of customers removed; all of these fields when the tool is used will contain data. So those columns must be ignored. There are also rows which contain no “Item ID” in [login to view URL], which should be ignored. It is very important that [login to view URL] remains unmodified except for the changes to the “Item Title” field. The order of the transactions cannot be changed. Also keep in mind the length of the “Item ID” field will cause scientific notation to be used unless the proper field type is used if you’re using excel libraries.
Project ID: 1191554

About the project

25 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Just completed a similar project. Please see PMB for more details.
$55 USD in 0 day
4.9 (174 reviews)
6.6
6.6
25 freelancers are bidding on average $76 USD for this job
User Avatar
Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)
$80 USD in 3 days
5.0 (158 reviews)
6.7
6.7
User Avatar
HI, I have a ready made tool that manipulates data of CSV and TXT files. Plz check PM Hussien Sharaf
$120 USD in 1 day
5.0 (61 reviews)
6.7
6.7
User Avatar
I can do this for you. See PM for details.
$40 USD in 0 day
5.0 (183 reviews)
6.3
6.3
User Avatar
Hi,I can do this job perfectly in C++/C/VB .Please check inbox for more details.
$40 USD in 2 days
4.8 (120 reviews)
6.2
6.2
User Avatar
I have lots of experience on Excel based data processing. Please see your messages. Thanks
$60 USD in 3 days
5.0 (66 reviews)
5.9
5.9
User Avatar
I plan to complete the project via writing an Excel macro contained in a separate XLS file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells to identify the current input and output files and hosting buttons and other controls. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards!
$120 USD in 2 days
4.9 (62 reviews)
5.7
5.7
User Avatar
Hi, I can write python script to process your data. Please check PMB for more details. Thanks.
$100 USD in 2 days
4.7 (40 reviews)
5.3
5.3
User Avatar
Hello! Please check PM for details. Thanks
$50 USD in 1 day
4.9 (33 reviews)
4.8
4.8
User Avatar
Hello, Please See the attached sample.. more details in PM... Microk
$35 USD in 1 day
4.8 (33 reviews)
4.5
4.5
User Avatar
Hello. I can help you with processing your CSV data. Please check private message for details. Thanks.
$100 USD in 2 days
4.6 (14 reviews)
4.4
4.4
User Avatar
Hi, i can do this for you.
$50 USD in 3 days
5.0 (6 reviews)
4.2
4.2
User Avatar
Please check PMB
$90 USD in 3 days
5.0 (10 reviews)
4.0
4.0
User Avatar
Details in the PM.
$200 USD in 2 days
4.8 (9 reviews)
3.4
3.4
User Avatar
Hi Detailed proposal in PM please
$50 USD in 3 days
5.0 (7 reviews)
3.2
3.2
User Avatar
Hello sir, please check the message for details.
$100 USD in 3 days
4.8 (2 reviews)
3.1
3.1
User Avatar
The task is clear. I can take care of this project.
$50 USD in 3 days
5.0 (2 reviews)
3.1
3.1
User Avatar
Will be able to complete this using Excel and VBA. Pls let me know. Thanks!
$40 USD in 1 day
5.0 (4 reviews)
2.5
2.5
User Avatar
Please read my PM for details of my bid.
$30 USD in 1 day
4.0 (1 review)
1.6
1.6
User Avatar
The details are in PMB.
$80 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can deliver the work in 1 day.
$100 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
waukesha, United States
4.9
14
Member since Jan 27, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.