Skip to main content

AWK one liners [part three]

contd.

sample files used for this tutorial.











1. Filteration of Row data

awk  ‘$3 == $4 {print $1 “    “ $3}’ abc.txt








awk -F “,” ‘$3 == $4 {print $1 “    “ $3}’ abc.csv









Here before printing the required rows we can filter it out using 

Some conditions.




2. Filteration of Row data with logical OR 


awk -F "," '$3 == 10000 || $4 == 10000 {print $1 "    " $2}' abc2.csv









3.  Filteration of Row data with logical AND


awk -F "," '$3 == 10000 && $4 == 10000 {print $1 "    " $2}' abc2.csv








Comments

Popular posts from this blog

Ubuntu Xrdp installation with Mate Desktop

The process for installation of Mate Desktop along with Xrdp on Ubuntu is as follows:  1. Update Repository      sudo apt update 2. Upgrade Ubuntu         Note: If asked to override PAM configuration, select No (and make         sure to select correct boot drive if requested)      sudo apt upgrade 3. Set iptables rules      sudo iptables -A INPUT -p tcp --dport 3389 -j ACCEPT      sudo iptables-save | sudo tee -a /etc/iptables/rules.v4      sudo reboot 4. Install xrdp and Mate Desktop      sudo apt install libgl1-mesa-dri fonts-dejavu mate-session-manager \      mate-panel marco caja mate-terminal mate-applet-brisk-menu \      mate-dock-applet mate-indicator-applet mate-indicator-applet-common \      ubuntu-mate-icon-themes mate-applets-common plank \      mate-hud mate-menu mate-apple...

Ldom Backup & Restore

1. Login to control Domain and list the current configuration file. bash-3.2# ldm list-spconfig basic_configuration new_configuration [current] 2.To take the complete LDOM configuration backup use below command. # ldm list-constraints -x >config.xml 3.You can also  take the configuration backup for specific LDOM # ldm list-constraints -x ldom_name > ldom_name.xml How to restore the system to factory default  1. Login to the control domain console and remove the spconfig profile. bash-3.2# ldm ls-spconfig basic_configuration new_configuration[current] bash-3.2# ldm  remove-spconfig new_configuration bash-3.2# ldm ls-spconfig basic_configuration [next poweron] 2.Power cycle the server to take the changes effect. bash-3.2# init 5 -> show /SYS   Properties:         type = Host System         ipmi_name = /SYS         keyswitch_state...

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...