Skip to content
GitLab

csvsed: sed for tabular data

Closed Administrator requested to merge github/fork/dhatim/csvsed into master

Created by: qauge

What about adding a csvsed utility to csvkit?

I think the name speaks for itself. Here is a short example:

$ cat sample.csv \
  | csvsed -c Wage -m s/,//g \                                     # remove commas from the Wage column
  | csvsed -c Status -m 'y/A-Z/a-z/' \                           # convert Status to all lowercase
  | csvsed -c Status -m 's/.*(ok|good).*/\1/'                 # restrict to keywords 'ok' & 'good'

The code (GPL) is adapted from https://github.com/metagriffin/csvsed with the authorization of its original author (metagriffin).

csvkit is amazing, by the way. I used it intensively during the last year. Thank you!