Is he doing this from memory or is he looking it up as he goes along?
Greg Laden's Blog
Evolution, Life Sciences, Science Education, Human Evolution, and Stuff
Learn more about Charles Darwin and his work.
Looking for stuff about birds?
Lean more about lions
An archaeological expedition to the Congo
The Skeptical Search Engine
The contents of Greg Laden's Blog are copyrighted by Greg Laden.
Recent Comments
- Greg Laden on What is Markdown and why use it?
- No one on New Theory of Dinosaur Extinction
- Satish Goda on Fun with the Linux seq command
- Donald Iljazi on What is Markdown and why use it?
- Greg Laden on The grey squirrel from a birder's point of view
- Charles on The grey squirrel from a birder's point of view
- Greg Laden on The grey squirrel from a birder's point of view
- Greg Laden on Seismic Activity at Yellowstone
- Connie Davis on Who has a higher IQ, cats or dogs?
- lynda on Seismic Activity at Yellowstone
Search
Profile
Click on "About" for the big picture, and "Archives" for the details.
Recent Posts
- Charles Darwin, Geologist
- Looking for stuff about birds?
- Environmentally Friendly Hard Drive Case
- Charles Darwin February 12, 1809 - April 19, 1882
- Whitney Houston has died
- Lions!
- Changing the rep of Fungi one mushroom-based robot thingie-builder at a time
- More Mississippi Meanderings
- Is climate change a leftist scientific conspiracy to destroy America?
- Oldest Animals Discovered in Namibia
Blogroll
If you don't see yourself on my blogroll, just drop me a line and let me know. I'll add you.*- 10,000 Birds
- Alpha Meme
- a Nadder!
- Angry by Choice
- Armchair Dissident
- (((Billy))) The Atheist
- blogfish
- blogSci
- Blond Nonbeliever
- Blue Lion Blog
- Bug Girl's Blog
- Camels with Hammers
- Catalogue of Oganisms
- Cassandra's Tears
- Class M Planet
- Cocktail Party Physics
- Counter Minds
- Cranky Linguist, The
- Crowded Head, Cozy Bed
- Dead Racist Society
- Deep Sea News
- Dispersal of Darwin
- Divine Afflatus
- Dread Tomato Addiction
- Evil is Underrated
- Evolved and Rational
- Evolving in Kansas
- Evolving Thoughts
- Fellman Studio Blog
- Flying Trilobite
- Further Thoughts
- Hoxful Monsters
- ICBS Everywhere
- Illusory Tenant
- It's Alive!!
- Jafcisa
- Letters from a Broad
- Life Before Death
- Looking For Detachment
- Matharu's Rants and Raves
- Mors dei
- Natural Reckonings
- Nature Blog Network
- Providentia
- Qeyḥ bāḥrī
- Quiche Moraine
- Religion, Sets, and Politics
- Sandwalk
- Sarah Zielinski
- Science Notes
- The Seething Primate
- Skepchick
- Spanish Inquisitor
- Splendid Elles
- Survival Machine
- Synapostasy
- TalkOrigins
- Tangled Up in Blue Guy
- Tetrapod Zoology
- The Flying Trilobite
- The Inoculated Mind
- The Intersection
- The Loom (new)
- The Scientific Activist
- The Unexamined Life..
- The Zone
- Thinking for Free
- Think Progress
- Three Toed Sloth
- Toomanytribbles
- Traumatized by Truth
- Truth Is a Woman
- udreamofjanie
- Uncommon Liberty
- View from the Pond
- Vickie Henderson Art
- When Pigs Fly Returns
- Writer's Daily Grind
Archives
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
« Five Gunned Down By Comrade in Iraq | Main | Party!!!! »
Command line magic: csv file processing
Category: Computer Tricks • Linux • Technology • one-liners
Posted on: May 11, 2009 3:57 PM, by Greg Laden
Find more posts in: 
Technology
TechnologyTrackBacks
TrackBack URL for this entry: http://scienceblogs.com/mt/pings/109277
Comments
I did "sort -t, -k3 test1 | join -v 1 -v 2 -t, -j 3 test2 -" and got essentially the same result (well, fields 1 and 3 were swapped, but big deal, hey?).
Posted by: lylebot | May 11, 2009 7:14 PM
er, "test1" and "test2" in my line correspond to "stuff.csv" and "nostuff.csv" respectively.
Posted by: lylebot | May 11, 2009 7:16 PM
I have been using PHP to do all my CSV parsing all this time. I should have known there'd be commands that could do it as easily in a bash script. Thanks Greg (and Linux Journal), I learned something new and will probably apply it sometime today. If not for work, then for fun.
Posted by: Jason Thibeault | May 12, 2009 8:28 AM
Probably from memory.
After using unix/sunos/solaris/aix/hpux/linux for almost two decades, I've memorized most of the options to the commonly used commands. I'm sure the author of the video has too.
Posted by: Glen | May 12, 2009 2:25 PM