Rcut (Reverse Cut)

Reverse cut (rcut ) is a preprocessor to Unix cut that allow to specify which columns to exclude, not which column to include into the output.  Here is one possible implementation (in bash)

#!/bin/bash
 
#=================================================================#
# Program       : rcut
# Description   : Same as "cut" except you specify the columns you want to EXCLUDE
# Author        : Anton Gorshkov
# Created       : 20040304
# Last Update   : 20040315 - Made Sorting Cleaner.
# Usage         : rcut -d<delim> -f<columns to exlude> <file> (can be piped to as well)
#================================================================#
 
usage="Usage: rcut -d<delim> -f<column to exlude> <file>"
while getopts ":d:f:" opt; do
  case $opt in
    d  ) delim=$OPTARG ;;
    f  ) excludeColumns=$OPTARG ;;
    \? ) echo $usage
         exit 1 ;;
  esac
done
shift $(($OPTIND -1))
 
if [ -z $delim ] || [ -z $excludeColumns ]; then
       echo $usage
       exit 1
fi
 
#This is to sort the columns as they need to be in order.
names=(`echo $excludeColumns | tr ',' '\012' |  sort -n | xargs`)
 
myStr=""
declare -i last=0
declare -i from=0
declare -i to=0
for i in "${names[@]}";do
 from=$last+1
 to=$i-1
 last=$i;
 if [ $i -gt $from ]; then
        myStr=$myStr$from-$to,
 fi
done
last=$last+1
myStr=$myStr$last-
cut -d "$delim" -f $myStr $1

NEWS CONTENTS

• 210210 : Introducing rcut ( Unix Review Shell Corner )

Old News ;-)

Introducing rcut

Unix Review Shell Corner

The cut command is one of the "arrows" in the shell programmer's "quiver". This month, Anton Gorshkov presents bash shell script rcut that performs an anti-cut operation. Rather than including columns, rcut excludes them.

reverse cut

Often when we deal with delimited files, we use the Unix cut command in order to output only certain columns, but more often we use it to exclude certain columns. For example, to exclude columns 4,5, and 10 from a pipe-delimited file, we would use:

cut -d"|" -f1-3,6-9,11- file.txt

This is a bit convoluted and it's not clear by looking at the command what is it doing.

Introducing rcut (reverse cut). This little script does exactly the opposite of cut. Instead of specifying which columns to include, you specify the columns you want to exclude. Thus, to accomplish the same thing as shown in the previous example, you would use:

rcut -d "|" -f4,5,10 file.txt 

which is a lot cleaner and easier to use.

Here is the bash script:

#!/bin/bash
 
#=================================================================#
# Program       : rcut
# Description   : Same as "cut" except you specify the columns you want to EXCLUDE
# Author        : Anton Gorshkov
# Created       : 20040304
# Last Update   : 20040315 - Made Sorting Cleaner.
# Usage         : rcut -d<delim> -f<columns to exlude> <file> (can be piped to as well)
#================================================================#
 
usage="Usage: rcut -d<delim> -f<column to exlude> <file>"
while getopts ":d:f:" opt; do
  case $opt in
    d  ) delim=$OPTARG ;;
    f  ) excludeColumns=$OPTARG ;;
    \? ) echo $usage
         exit 1 ;;
  esac
done
shift $(($OPTIND -1))
 
if [ -z $delim ] || [ -z $excludeColumns ]; then
       echo $usage
       exit 1
fi
 
#This is to sort the columns as they need to be in order.
names=(`echo $excludeColumns | tr ',' '\012' |  sort -n | xargs`)
 
myStr=""
declare -i last=0
declare -i from=0
declare -i to=0
for i in "${names[@]}";do
 from=$last+1
 to=$i-1
 last=$i;
 if [ $i -gt $from ]; then
        myStr=$myStr$from-$to,
 fi
done
last=$last+1
myStr=$myStr$last-
cut -d "$delim" -f $myStr $1

A Korn shell script will look very similar:

#! /bin/ksh -f
 
usage="Usage: rcut -d<delim> -f<column to exlude> <file>"
while getopts ":d:f:" opt; do
  case $opt in
    d  ) delim=$OPTARG ;;
    f  ) excludeColumns=$OPTARG ;;
    \? ) echo $usage
         exit 1 ;;
  esac
done
shift $(($OPTIND -1))
 
if [ -z $delim ] || [ -z $excludeColumns ]; then
       echo $usage
       exit 1
fi
 
#Don't have to sort, KornShell does it for you!
set -sA names `echo $excludeColumns | sed -e 's/,/ /g'`
 
myStr=""
last=0
from=0
to=0
for i in "${names[@]}";do
 ((from=$last+1))
 ((to=$i-1))
 ((last=$i))
 if [ $i -gt $from ]; then
        myStr=$myStr$from-$to,
 fi
done
((last=$last+1))
myStr=$myStr$last-
 
cut -d${delim} -f$myStr $1

Besides the difference in mathematical expressions, the big advantage of Korn shell in this case is that it allows you to declare a sorted array. Not that it's a big deal to sort, I just find that Korn shell is a lot cleaner in this case.

One practical application for rcut is if you want to compare two files and ignore certain columns. In fact, I wrote rcut just for that purpose. Imagine you have two files that contain the same contact information:

File1:

Id |Fname|Lname     |Month  |Day    |UpdateDate
1  |Anton|Gorshkov  |May    |20     |03/18/2004
2  |John |Doe       |Dec    |19     |02/01/2004
3  |Ed   |Schaefer  |March  |11     |05/29/2003

File2:

Id |Fname|Lname     |Month  |Day    |UpdateDate
1  |John |Doe       |Dec    |19     |08/31/2002
2  |Ed   |Schaefer  |March  |11     |09/09/2001
3  |Anton|Gorshkoff |May    |20     |05/28/2002

You want to find out which contacts are out of sync, but you don't care about the "Id" and the "UpdateDate" field. I wrote another little script called diffi (diff ignore) that compares two files, sorting them prior to comparison and ignores specified columns even if they are different:

#!/bin/bash

#==================================================================#
# Program       : diffi
# Description   : diff that allows you to exclude columns. (requires rcut)
# Author        : Anton Gorshkov
# Created	 : 20040319
# Last Update   : 20040319 - Initial Implementation
# Usage		 : diffi -d<delim> -f<columns to exlude> <file1> <file2>
#=================================================================#

usage="Usage: diffi -d<delim> -f<columns to exlude> <file1> <file2>"
while getopts ":d:f:" opt; do
  case $opt in
    d  ) delim=$OPTARG ;;
    f  ) excludeColumns=$OPTARG ;;
    \? ) echo $usage
	 exit 1 ;;
  esac
done
shift $(($OPTIND -1))

if [ -z $delim ] || [ -z $excludeColumns ]; then
       echo $usage
       exit 1
fi

rcut -d$delim -f$excludeColumns $1 | sort > $1.cut
rcut -d$delim -f$excludeColumns $2 | sort > $2.cut

diff $1.cut $2.cut

rm $1.cut $2.cut

Usage: diffi -d"|" -f1,6 file1 file2

This will show you that the only different contact is me. (LName is misspelled). Notice that this script is not "perfect" in a sense that it doesn't support any standard diff options, but that could be incorporated.

Recommended Links

Softpanorama Recommended

Top articles

Sites

cut command

Etc

Society

Groupthink : Two Party System as Polyarchy : Corruption of Regulators : Bureaucracies : Understanding Micromanagers and Control Freaks : Toxic Managers :   Harvard Mafia : Diplomatic Communication : Surviving a Bad Performance Review : Insufficient Retirement Funds as Immanent Problem of Neoliberal Regime : PseudoScience : Who Rules America : Neoliberalism  : The Iron Law of Oligarchy : Libertarian Philosophy

Quotes

War and Peace : Skeptical Finance : John Kenneth Galbraith :Talleyrand : Oscar Wilde : Otto Von Bismarck : Keynes : George Carlin : Skeptics : Propaganda  : SE quotes : Language Design and Programming Quotes : Random IT-related quotes :  Somerset Maugham : Marcus Aurelius : Kurt Vonnegut : Eric Hoffer : Winston Churchill : Napoleon Bonaparte : Ambrose Bierce :  Bernard Shaw : Mark Twain Quotes

Bulletin:

Vol 25, No.12 (December, 2013) Rational Fools vs. Efficient Crooks The efficient markets hypothesis : Political Skeptic Bulletin, 2013 : Unemployment Bulletin, 2010 :  Vol 23, No.10 (October, 2011) An observation about corporate security departments : Slightly Skeptical Euromaydan Chronicles, June 2014 : Greenspan legacy bulletin, 2008 : Vol 25, No.10 (October, 2013) Cryptolocker Trojan (Win32/Crilock.A) : Vol 25, No.08 (August, 2013) Cloud providers as intelligence collection hubs : Financial Humor Bulletin, 2010 : Inequality Bulletin, 2009 : Financial Humor Bulletin, 2008 : Copyleft Problems Bulletin, 2004 : Financial Humor Bulletin, 2011 : Energy Bulletin, 2010 : Malware Protection Bulletin, 2010 : Vol 26, No.1 (January, 2013) Object-Oriented Cult : Political Skeptic Bulletin, 2011 : Vol 23, No.11 (November, 2011) Softpanorama classification of sysadmin horror stories : Vol 25, No.05 (May, 2013) Corporate bullshit as a communication method  : Vol 25, No.06 (June, 2013) A Note on the Relationship of Brooks Law and Conway Law

History:

Fifty glorious years (1950-2000): the triumph of the US computer engineering : Donald Knuth : TAoCP and its Influence of Computer Science : Richard Stallman : Linus Torvalds  : Larry Wall  : John K. Ousterhout : CTSS : Multix OS Unix History : Unix shell history : VI editor : History of pipes concept : Solaris : MS DOS :  Programming Languages History : PL/1 : Simula 67 : C : History of GCC development :  Scripting Languages : Perl history   : OS History : Mail : DNS : SSH : CPU Instruction Sets : SPARC systems 1987-2006 : Norton Commander : Norton Utilities : Norton Ghost : Frontpage history : Malware Defense History : GNU Screen : OSS early history

Classic books:

The Peter Principle : Parkinson Law : 1984 : The Mythical Man-Month :  How to Solve It by George Polya : The Art of Computer Programming : The Elements of Programming Style : The Unix Hater’s Handbook : The Jargon file : The True Believer : Programming Pearls : The Good Soldier Svejk : The Power Elite

Most popular humor pages:

Manifest of the Softpanorama IT Slacker Society : Ten Commandments of the IT Slackers Society : Computer Humor Collection : BSD Logo Story : The Cuckoo's Egg : IT Slang : C++ Humor : ARE YOU A BBS ADDICT? : The Perl Purity Test : Object oriented programmers of all nations : Financial Humor : Financial Humor Bulletin, 2008 : Financial Humor Bulletin, 2010 : The Most Comprehensive Collection of Editor-related Humor : Programming Language Humor : Goldman Sachs related humor : Greenspan humor : C Humor : Scripting Humor : Real Programmers Humor : Web Humor : GPL-related Humor : OFM Humor : Politically Incorrect Humor : IDS Humor : "Linux Sucks" Humor : Russian Musical Humor : Best Russian Programmer Humor : Microsoft plans to buy Catholic Church : Richard Stallman Related Humor : Admin Humor : Perl-related Humor : Linus Torvalds Related humor : PseudoScience Related Humor : Networking Humor : Shell Humor : Financial Humor Bulletin, 2011 : Financial Humor Bulletin, 2012 : Financial Humor Bulletin, 2013 : Java Humor : Software Engineering Humor : Sun Solaris Related Humor : Education Humor : IBM Humor : Assembler-related Humor : VIM Humor : Computer Viruses Humor : Bright tomorrow is rescheduled to a day after tomorrow : Classic Computer Humor

The Last but not Least Technology is dominated by two types of people: those who understand what they do not manage and those who manage what they do not understand ~Archibald Putt. Ph.D

The statements, views and opinions presented on this web page are those of the author (or referenced source) and are not endorsed by, nor do they necessarily reflect, the opinions of the Softpanorama society. We do not warrant the correctness of the information provided or its fitness for any purpose. The site uses AdSense so you need to be aware of Google privacy policy. You you do not want to be tracked by Google please disable Javascript for this site. This site is perfectly usable without Javascript.

Last modified: March, 12, 2019