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.


If you have a new feature suggestion or find a bug, please get in touch via http://commandlinefu.uservoice.com/

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.

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

2011-03-12 - Confoo 2011 presentation
Slides are available from the commandlinefu presentation at Confoo 2011: http://presentations.codeinthehole.com/confoo2011/
2011-01-04 - Moderation now required for new commands
To try and put and end to the spamming, new commands require moderation before they will appear on the site.
2010-12-27 - Apologies for not banning the trolls sooner
Have been away from the interwebs over Christmas. Will be more vigilant henceforth.
2010-09-24 - OAuth and pagination problems fixed
Apologies for the delay in getting Twitter's OAuth supported. Annoying pagination gremlin also fixed.
Hide

Tags

Hide

Functions

Commands tagged format from sorted by
Terminal - Commands tagged format - 8 results
echo "select a, b, c from table where a = 3;"| python -c "import sys;import sqlparse;print sqlparse.format(sys.stdin.read(), reindent=True, keyword_case='upper')"
2014-02-21 23:17:15
User: hide1713
Functions: echo python
1

You need to apt-get install python-sqlparse. This command simply formats a sql query and prints it out. It is very useful when you want to move a sql query from commandline to a shell script. Everything is done locally, so you don't need to worry about copying sql query to external websites.

vim +"bufdo norm gg=G" +wa +qa FILES
2013-12-06 22:15:24
User: pjump
Functions: vim
0

The equivalent of opening each file in vim and doing

gg=G:wq . Bufdo makes it faster by obviating the need to start vim for each file separately.

stat -f -L -c %T YOUR_FILE_OR_DIRECTORY
mke2fs -t ext4 -O ^has_journal /dev/sdXN
1

For slow flash memory (cheap thumb drive), ext4 is the fastest stable file system for all use cases with no relevant exception:

http://www.linuxplanet.com/linuxplanet/tutorials/7208/1

Since we can usually dispense with the benefits of a journal for this type of storage, this is a way to achieve the least awful I/O-speed.

Disabling the journal for an existing ext4 partition can be achieved using

tune2fs -O ^has_journal /dev/sdXN

Note that it is often recommended to format removable flash media with ext2, due to the lack of a journal. ext4 has many advantages over ext2 even without the journal, with much better speed as one of the consequences. So the only usecase for ext2 would be compatibility with very old software.

tidy -i -xml <inputfile>
2012-11-03 18:10:58
User: Testuser_01
8

This will indent the input to be more readable. Warnings and messages are not send to STDOUT so you can just use a pipe to create the formatted outputfile, like:

tidy -i -xml in.xml > out.xml
echo '<foo><bar/></foo>' | xmllint --format -
sox is_that_correct.wav -t raw -r 8000 -s -w -c 1 is_that_correct.sln
find $DIR -name *.php -exec vim -u NONE -c 'set ft=php' -c 'set shiftwidth=4' -c 'set tabstop=4' -c 'set noexpandtab!' -c 'set noet' -c 'retab!' -c 'bufdo! "execute normal gg=G"' -c wq {} \;
2011-04-08 11:42:45
User: ruslan
Functions: find vim
-2

The sample command searches for PHP files replacing tabs with spaces.

-u NONE # don't use vimrc

Instead of

retab!

one may pass

retab! 4

for instance.

Look at this http://susepaste.org/69028693 also