scrubcsv

Provides a linux/unix command line tool to "scrub" comma delimited files. Removing extra spaces, mr. dr. etc. Also removing duplicate records based on a comparison of columns/fields. It's a bash script using awk, cut, join and nl. Using a little perl

Project Samples

scrubcsv.sh -p13 -c5 -c6 input.csv 5 6 13

Project Activity

See All Activity >

License

GNU General Public License version 2.0 (GPLv2)

Follow scrubcsv

scrubcsv Web Site

Other Useful Business Software

Powering the next decade of business messaging | Twilio MessagingX

For organizations interested programmable APIs built on a scalable business messaging platform

Build unique experiences across SMS, MMS, Facebook Messenger, and WhatsApp – with our unified messaging APIs.

Learn More

Rate This Project

User Reviews

Be the first to post a review of scrubcsv!

Additional Project Details

Operating Systems

Linux, BSD

Intended Audience

Information Technology

User Interface

Console/Terminal, Command-line

Programming Language

Unix Shell

Database Environment

Flat-file

Related Categories

Unix Shell Database Software, Unix Shell Command Line Tools

Registered

2006-09-29

Similar Business Software

LOLCODE

LOLCODE can interpret files from standard input or from a file. Spaces are used to demarcate tokens in the language, although some keyword constructs may include spaces. Multiple spaces and tabs are treated as single spaces and are otherwise irrelevant. Indentation is irrelevant. A command...

See Software
Testsigma

Testsigma is a low-code end-to-end software testing platform that works out of the box. It's built to enable modern Product teams to collaboratively plan, develop, execute, analyze, debug, and report on their automated testing—for websites, native Android and iOS apps, and APIs. Testsigma...

See Software
TeamDesk

TeamDesk is the leading AI-Powered Low-Code platform for creating powerful and flexible web-based databases with no-coding. AI-Assisted Development streamlines database design, no technical skills required. TechRadar named TeamDesk as the best database platform of the year. TeamDesk...

See Software

Report inappropriate content