Skip to main content

AWK one liners [part two]

contd..


Here is a sample csv file












1. Print columns from a csv file 


awk -F "," '{print $1}' abc.csv










awk -F "," '{print $1 "    " $3}' abc.csv










Where -F defines the seperator.


There is an alternate method to use the field separator









Here FS is used to define the filed separator which is “,” in 

this case it could be a whitespace , a tab etc.



2. Display Content of the file without displaying header


awk 'NR!=1 {print $1 "    " $2}' abc.txt











awk 'NR>2 {print $1 "    " $2}' abc.txt











Where NR indicates the row number



3. Saving AWK output to a separate file







Comments

Popular posts from this blog

Setting up X11 Access to the Solaris GUI Gnome Desktop

How to   access the GUI desktop environment on a Solaris 11 SPARC server from Windows, MAC, Solaris or Linux desktop computer. As most of the time SPARC based servers are installed using the Oracle Solaris 11 Text  Installer (installing the solaris-large-server group of software packages), the desktop  environment is not installed (mostly to keep the system lightweight) . So the only option for connecting remotely to the server is with an SSH client and a command line interface  (Known as Terminal). Most widely used software to connect to a command line is Putty. For beginners , who haven’t worked on any unix/linux system , it takes time to adjust to the commands and syntax of terminals (The so called black screen).   Installation Overview To accomplish our task   we will   follow these three steps: 1. Install the Gnome desktop environment on our SPARC server. Note – If we use the text installation method, the Oracle Solaris Desktop package (solar...

AWK one liners [part one]

AWK was initially developed in 1977 by Alfred Aho , Peter J Wienberger  and Brian Kernighan. And hence the name(AWK) derived from  their respective initials. AWK was designed basically for text processing and used mostly for  extraction  a nd manipulation of data. For more info  :  visit here Lets start with the examples. 1. Print Specific Column from a file sample file created awk '{print $1 "   " $3}' abc.txt awk '{print $1 "   " $3}' abc.txt 2. Print all data from a table awk '{print $0}' abc.txt

Root Password Recovery Solaris 11

1. Set the auto-boot options to false.  ldm set-variable auto-boot\?=false Ldom-name 2. To check the disk resources attached to your ldm  ldm list -o disk Ldom-name 3. Check for any existing services on Primary/IO Domain  ldm list-services primary 4. You can use the existing one , if any or else create a new one. l dm add-vds primary-cdrom primary 5. Add a vdsdev to the service created in step 4 l dm add-vdsdev options=ro  /tmp/sol-11_2-text-sparc.iso  cdrom01@primary-cdrom where ro=read-only /tmp/sol-11_2-text-sparc.iso = path of The Solaris 11 iso image   6. Add a virtual disk to the vdsdev created in step 5 l dm add-vdisk cdrom cdrom01@primary-cdrom Ldom-name 7. From the primary domain break into the ldom whose password is to be recovered telnet 0 500x (ldm port number) Trying 0.0.0.0.. Connected to 0 Escape character is '^]' telnet> send break c)ontinue, s)ync, r)eset? Enter r Resetting.. NOTICE: ...