Find Jobs
Hire Freelancers

Correct CSV File Tool

$5-10 USD

Completed
Posted almost 14 years ago

$5-10 USD

Paid on delivery
A Tool is needed, which replaces specific characters (mostly control characters from 01 to 1F) in a CSV file. Input: CSV file - It must be possible to pick a CSV file. The CSV file is semicolon (;) separated, and if a value contains spaces or specific characters, that value is embedded in quotes ("..."). (CSV standard) Processing (in this order): 1. If a field contains a leading equal character (=), that character must be removed. Equal characters within the field must be left intact. 2. CRLF ($0D$0A) must be replaced with {Space}//{Space} ($20//$20) anywhere within the field. 3. TAB ($09) must be replaced with {Space}{Space}{Space}{Space} ($20$20$20$20) anywhere within the field. 4. Any control character from $01 to $1F must be removed without replacement. Output: The corrected CSV file with a "_cleaned" extension in the filename. ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the worker's Worker Legal Agreement). Disclaimer: The code must be fully tested before the job is delivered. I will only go through a single test cycle and specify a maximum of two bugs during that cycle, and I will not find bugs and correct the function myself. You agree that you will lose arbitration in case you deliver a function that is not working as specified on the second delivery. In other words, please test your code thoroughly before you deliver and do not rely that it will work. ## Platform SQL Server 2000 Please note this is for SQL Server 2000 and TSQL, not a compiled .NET assembly.
Project ID: 3503543

About the project

1 proposal
Remote project
Active 14 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
See private message.
$5 USD in 5 days
4.6 (96 reviews)
5.8
5.8

About the client

Flag of SPAIN
Madrid, Spain
5.0
65
Member since Oct 14, 2003

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.