Hide

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again.

Delete that bloated snippets file you've been using and share your personal repository with the world. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.


Get involved!

You can sign-in using OpenID credentials, or register a traditional username and password.

First-time OpenID users will be automatically assigned a username which can be changed after signing in.

Universal configuration monitoring and system of record for IT.
Hide

Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for:

Hide

News

May 19, 2015 - A Look At The New Commandlinefu
I've put together a short writeup on what kind of newness you can expect from the next iteration of clfu. Check it out here.
March 2, 2015 - New Management
I'm Jon, I'll be maintaining and improving clfu. Thanks to David for building such a great resource!
Hide

Top Tags

Hide

Functions

Psst. Open beta.

Wow, didn't really expect you to read this far down. The latest iteration of the site is in open beta. It's a gentle open beta-- not in prime-time just yet. It's being hosted over at UpGuard (link) and you are more than welcome to give it a shot. Couple things:

  • » The open beta is running a copy of the database that will not carry over to the final version. Don't post anything you don't mind losing.
  • » If you wish to use your user account, you will probably need to reset your password.
Your feedback is appreciated via the form on the beta page. Thanks! -Jon & CLFU Team

Convert CSV files to TSV

Terminal - Convert CSV files to TSV
sed 's/,/\t/g' report.csv > report.tsv
2009-07-23 15:39:03
User: viner
Functions: sed
0
Convert CSV files to TSV

Convert comma separated files to tab separated files.

(MySQL eats tab separated files with much less instruction than comma seperated files.)

Alternatives

There is 1 alternative - vote for the best!

Terminal - Alternatives

Know a better way?

If you can do better, submit your command here.

What others think

This will fail on fields which contain commas inside quoted strings.

Comment by andrew112358 391 weeks ago

CSV RFC http://www.ietf.org/rfc/rfc4180.txt Section 2.5

Comment by kzh 390 weeks and 6 days ago

Michael Kors BagsThe range of fragrances your cruise trip filling will probably most surely keep will definitely count on the particular boat excursion line. Virtually all motorboats excursion boats are able to prepare the alternatively fantastic use of items. Hunt for several big ultra superstars (Givenchy,, Lancome, and so on) and many much more existing titles (DKNY, Website, Notara Wang).Micael Kors seemed to be birthed upon Your five August Last year about Ny New York. They was called Karl Andersen Junior, referred to as soon after his / her pops Karl Andesen. His or her mommy remarried while he seemed to be A few and the man was proven a decision to boost the tag. This individual chosen over end up being termed Micheal Jesse Kors. Micheal Kors became a property indicate as a superstar judge around the personal precious television institution Process Driveway.In Early 90's, Gianni Versace created nominal type number of bracelets designer watches, deriving by assistance between your famous developer Franck Muller, who designed and also made the product range throughout Geneva. Versace is associated with elegance, school and attention to precise, and that is reflected inside their view assortment.The take bags are additionally easily available throughout slouchy styles made from gentle natural leather using strap layout handles. The bag in python gold buckskin is definitely each roomy and complicated any way you like and is the perfect on the run handbag for any sort of female who would rather go shopping. The particular bags inside Darrington variety use a trendier model using silver accented buckles as well as straps managing over the entrance surface. The gold accessories glimpse in particular stunning whenever suited for any black color place. These things furthermore have got area storage compartments which have zippered closures.Michael Kors Handbags Wall structure put specializes in design and style pattern as well as innovative templates which will certainly interesting to some modern-day buyers. The watch series target sophisticated and complicated designer watches which may have regular capabilities having striking artistic special gems. Amazing normal buckskin or even stainless-steel hand artists, mother-of-pearl face encounters, designer watches together with give up designer watches in addition to good-looking steels are merely many of the features which are highlighted straight into likes.IF you are searching for a bit as well as posh wristlet with a custom made touch, the actual Erika Prescott Wristlet is an ideal solution. That captivating wristlet incorporates a teasing synthetic leather wristlet secure, a zip best with buckskin pull, ruched info, logo company logo laser engraved breeze along with a ruched top pants pocket. This Michael Prescott Wristlet is constructed from wash rag using gold tone components and it's easily accessible from the shades vanilla flavour black or white. Have a look at on the net for further obtainable colorings.As if it record associated with parts has not been wonderful ample industry expense about this bag is actually $198.Double zero. That bag is capable of supporting up almost any almost fall clothing. The retail price tag with this bag furthermore helps it be easily intended for just about anyone. Always be forewarned, several of the Bags Luggage can certainly http://www.hermesbeltsbirkinkellybag.co.uk/ possibly identify you actually again close to $3,000.Michael Kors wristwatches received a completely around the world warranty which can be expert for a few many years through the night out of economic expenditure. You will need to basically maintain repeat of the receipt to acquire circumstances in the event the enjoy does not work properly using the ensure length of time. Enterprise scenarios to make cost-free restore careers and replacements during the entire assurance length. Basic within situations you've got fetish with regard to view in that case your wide variety will definitely should have a single.

Comment by stephanieg915 3 days ago

How does one like to spend great time with loved ones over this weekend? Please don't you believe getaway to some places just like body of water, seashore refresh brain coming from busy timetable associated with business office?If yes, thenyou must not hold off in making this sort of software with him or her?You are able to distort feeling simply by taking part in different online games for instance beach volleyball and whip involving struggle near resort place. You may be fond of bold sports so, just how about an concept of using high tides with seashore by way of surfing? You can actually take interest regarding crowd by means of drifting human body about particular tools like wakeboards& bindings in marine. Isnt it, right?Course instructors will also be useful to guide you quite a few hints in this route regarding strategy. They're accomplished ample inside providing expertise relating to samsung wave s8500 dynamics and they also teach you steps to make sense of balance with a reliable wood. And so, what about your current viewpoint to produce ambitions become a when it comes to this kind of audacious activities with their aid?During nighttime, it is possible to spend precious a long time pertaining to buying to be able to purchase variety of things such as denim jeans, skirts and also tote by mallfor family. Do not you pumped up about the item? Soft gadgets like teddy light beer, penguin and also tweety are nice options to bring giggle upon children's encounter.You are able to enhance space along with show-pieces for instance Oriental gong, smaller diary booklet and beautiful surroundings inside a distinct fashion.These add-ons are really simple to carry inside brandedpackaging bags using secure and safe.Have you found that complicated cope with ofcarrier bags manufactured from United kingdom seem eye-catching give? In this way, an individual specifically put grace to be able to individuality whilst transporting all of them from one spot to another. These kinds of Labeled Service Bagsare specifically created by accomplished specialists to help http://www.hermesbeltsbirkinkellybag.co.uk/ you totally free of any mishappenings linked to deterioration and also the break point of products.They will use best content to make this kind of products magnificent.Online art gallery is gainful to place a purchase order of these exceptional items from your home. It will save you precious time using this method.One can choose from unique tones along with consistency in so doing you can actually personalize these kinds of polythene bags in line with the demands with the Labeled Presentation. You get these people with realistic rates which straight fits spending budgets.Because of rise in demand of this kind of objects, providers upload along with scan those to numerous parts of world.So, you should perhaps refer to them as as soon as possible for making difference in total well being.

Comment by stephanieg915 3 days ago

http://www.canadagoosefemmehomme2016.fr/heli-arctic-canada-goose_441.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-mystique-femme_179.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-boutique-en-ligne_184.html,http://www.canadagoosefemmehomme2016.fr/doudoune-canada-goose-rose_421.html,http://www.canadagoosefemmehomme2016.fr/homme-canada-goose_350.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-noir_45.html,http://www.canadagoosefemmehomme2016.fr/manteau-canada-goose-femme-pas-cher_472.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-solaris-parka_375.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-accessoires_183.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-camp-hoody_50.html,http://www.canadagoosefemmehomme2016.fr/parka-canada-goose_120.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-original_190.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-lodge_76.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-femme-grise_145.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-cramoisi_47.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-femme-bleu-marine_151.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-graphite_389.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-fourrure-coyote_244.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-parka-langford_176.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-suisse_41.html,http://www.canadagoosefemmehomme2016.fr/canada-goose-pbi-chilliwack-bomber_73.html,http://www.canadagoosefemmehomme2016.fr/goose-femme_52.html,http://www.canadagoosefemmehomme2016.fr/manteau-type-canada-goose_369.html,http://www.canadagoosefemm

Comment by sguerra376 2 days ago

www.canadagoosefemmehomme2016.fr

www.canadagoosefemmehomme2016.fr/canada-goose-chilliwack-femme-occasion_464.html

www.canadagoosefemmehomme2016.fr/canada-goose-chilliwak_109.html

www.canadagoosefemmehomme2016.fr/canada-goose-yorkville-bomber_408.html

www.canadagoosefemmehomme2016.fr/canada-goose-rundle_453.html

www.canadagoosefemmehomme2016.fr/canada-goose-au-canada-prix_54.html

www.canadagoosefemmehomme2016.fr/canada-goose-solaris-parka_375.html

www.canadagoosefemmehomme2016.fr/vrai-canada-goose-pas-cher_40.html

www.canadagoosefemmehomme2016.fr/manteau-canada-goose-a-vendre_450.html

www.canadagoosefemmehomme2016.fr/canada-goose-prix_56.html

www.canadagoosefemmehomme2016.fr/canada-goose-manteau-femme_178.html

www.canadagoosefemmehomme2016.fr/canada-goose-sherbrooke_245.html

www.canadagoosefemmehomme2016.fr/canada-goose-doudoune-sans-manche-homme_291.html

www.canadagoosefemmehomme2016.fr/expedition-parka-canada-goose_210.html

www.canadagoosefemmehomme2016.fr/canada-goose-camp-hoody_50.html

www.canadagoosefemmehomme2016.fr/canada-goose-bleu_63.html

www.canadagoosefemmehomme2016.fr/hommes-canadian-goose_102.html

www.canadagoosefemmehomme2016.fr/canada-goose-logo_212.html

www.canadagoosefemmehomme2016.fr/goose-canada_169.html

www.canadagoosefemmehomme2016.fr/canada-goose-achat_221.html

www.canadagoosefemmehomme2016.fr/canada-goose-chelsea_326.html

www.canadagoosefemmehomme2016.fr/blouson-canada-goose-homme_467.html

www.canadagoosefemmehomme2016.fr/canada-goose-lodge_76.html

www.canadagoosefemmehomme2016.fr/canada-goose-chateau-pas-cher_173.html

www.canadagoosefemmehomme2016.fr/doudoune-canada-goose-rose_421.html

www.canadagoosefemmehomme2016.fr/blouson-goose-canada_195.html

Comment by sguerra376 1 day ago

http://www.canadagoosefemmehomme2016.fr/canada-goose-site-officiel_57.html

http://www.canadagoosefemmehomme2016.fr/doudoune-canada-goose-france_265.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-modele-victoria_409.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-canada-prix_284.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-kensington-parka-femme_448.html

http://www.canadagoosefemmehomme2016.fr/manteau-canada-goose-femme-prix_422.html

http://www.canadagoosefemmehomme2016.fr/shelburne-canada-goose_418.html

http://www.canadagoosefemmehomme2016.fr/chaussure-canada-goose_230.html

http://www.canadagoosefemmehomme2016.fr/parka-canada-goose-chateau_400.html

http://www.canadagoosefemmehomme2016.fr/tuque-canada-goose_439.html

http://www.canadagoosefemmehomme2016.fr/victoria-parka-canada-goose_338.html

http://www.canadagoosefemmehomme2016.fr/boutique-canada-goose-montreal_456.html

http://www.canadagoosefemmehomme2016.fr/revendeur-canada-goose_106.html

http://www.canadagoosefemmehomme2016.fr/acheter-canada-goose-montreal_351.html

http://www.canadagoosefemmehomme2016.fr/parka-canada-goose-montebello_214.html

http://www.canadagoosefemmehomme2016.fr/parka-canada-goose-expedition_381.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-lyon_237.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-new-york-prix_159.html

http://www.canadagoosefemmehomme2016.fr/doudoune-longue-canada-goose_447.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-bonnet_135.html

http://www.canadagoosefemmehomme2016.fr/canada-goose-luxembourg_51.html

Comment by sguerra376 13 hours ago

www.canadagoosefemmehomme2016.fr/canada-goose-site-fiable_136.html

www.canadagoosefemmehomme2016.fr/doudoune-canada-goose-solde_316.html

www.canadagoosefemmehomme2016.fr/canada-goose-kensington_86.html

www.canadagoosefemmehomme2016.fr/parka-canada-goose-expedition_381.html

www.canadagoosefemmehomme2016.fr/acheter-une-canada-goose_177.html

www.canadagoosefemmehomme2016.fr/constable-canada-goose_67.html

www.canadagoosefemmehomme2016.fr/canada-goose-parka-femme_349.html

www.canadagoosefemmehomme2016.fr/acheter-canada-goose-montreal_351.html

www.canadagoosefemmehomme2016.fr/femmes-canada-goose_281.html

www.canadagoosefemmehomme2016.fr/canada-goose-canada_386.html

www.canadagoosefemmehomme2016.fr/gilet-canada-goose_185.html

www.canadagoosefemmehomme2016.fr/canada-goose-kensington-parka-femme_448.html

www.canadagoosefemmehomme2016.fr/canada-goose-point-de-vente_371.html

www.canadagoosefemmehomme2016.fr/le-bon-coin-canada-goose_157.html

www.canadagoosefemmehomme2016.fr/veste-canada-goose-femme_274.html

www.canadagoosefemmehomme2016.fr/chilliwack-bomber-canada-goose_372.html

www.canadagoosefemmehomme2016.fr/canada-goose-langford_320.html

www.canadagoosefemmehomme2016.fr/canada-goose-femme-pas-cher_139.html

www.canadagoosefemmehomme2016.fr/canada-goose-victoria-parka_462.html

www.canadagoosefemmehomme2016.fr/canada-goose-modele-victoria_409.html

www.canadagoosefemmehomme2016.fr/gants-canada-goose_312.html

www.canadagoosefemmehomme2016.fr/parka-canada-goose-soldes_241.html

www.canadagoosefemmehomme2016.fr/prix-d-une-doudoune-canada-goose_390.html

www.canadagoosefemmehomme2016.fr/canada-goose-toronto-outlet_483.html

Comment by sguerra376 1 hour ago

Your point of view

You must be signed in to comment.