This command will read a CSV file, and display it as columns. This also works on Windows if you have Cygwin installed.
column -t -s"," test.csv
Archives
September 2018May 2016
October 2015
August 2014
May 2014
January 2014
December 2013
October 2013
September 2013
August 2013
July 2013
June 2013
May 2012
February 2012
December 2011
October 2011
June 2011
March 2011
September 2010
June 2010
May 2010
March 2010
Categories
Code (30)Electronics (2)
Freelancer (1)
Personal (2)
Projects (1)
Systems (14)
Uncategorized (2)
Read a CSV file into columns
May 6th, 2016Tags: columns, command, csv, display, file
Posted in Code, Systems | No Comments »
MySQL Dump And Restore Database Table With Compression
August 30th, 2014mysqldump --no-create-info -uxxxx -pxxxx Database ATable | gzip -9 > xxxx.sql.gz
zcat xxxx.sql.gz | mysql -uxxxx -pxxxx Database
Tags: admin, backup, cli, command, dump, linux, mysql, mysqldump, restore, server, sysadmin, zcat
Posted in Code, Systems | No Comments »
PHP Class To Color CLI Output
July 31st, 2013A guy named JR posted this nifty piece of code to help color CLI output in bash from PHP scripts
And this user on GitHub cleaned it up a bit and posted a Gist of it.
Tags: class, cli, Code, color, command, console, gist, php
Posted in Code, Systems | No Comments »
Strip Whitespace Out Of A File
June 6th, 2013sed is a wonderful tool. Just used this command today to remove most of the whitespace from a file.
sed 's/ //g' test.txt > test2.txt
Tags: cli, command, linux, manipulation, sed, systems, text
Posted in Code, Systems | No Comments »
Making A USB Hard Drive Bootable
June 25th, 2011Vista and Windows 7 DVDs include a utility to make a USB hard drive bootable so you can install from them.
The command for this is:
[code]E:\boot\bootsect.exe /nt60 F:[/code]
where E is the DVD drive, and F is the hard drive that you want bootable.
Once you’ve done this, you can copy the contents of the DVD to the USB hard drive, and install from that. Great for when you didn’t buy a SATA DVD drive for your new computer 😀
Tags: cli, command, usb, vista, windows
Posted in Systems | No Comments »