\documentclass[10pt,a4paper]{article}

% Packages
\usepackage{fancyhdr}           % For header and footer
\usepackage{multicol}           % Allows multicols in tables
\usepackage{tabularx}           % Intelligent column widths
\usepackage{tabulary}           % Used in header and footer
\usepackage{hhline}             % Border under tables
\usepackage{graphicx}           % For images
\usepackage{xcolor}             % For hex colours
%\usepackage[utf8x]{inputenc}    % For unicode character support
\usepackage[T1]{fontenc}        % Without this we get weird character replacements
\usepackage{colortbl}           % For coloured tables
\usepackage{setspace}           % For line height
\usepackage{lastpage}           % Needed for total page number
\usepackage{seqsplit}           % Splits long words.
%\usepackage{opensans}          % Can't make this work so far. Shame. Would be lovely.
\usepackage[normalem]{ulem}     % For underlining links
% Most of the following are not required for the majority
% of cheat sheets but are needed for some symbol support.
\usepackage{amsmath}            % Symbols
\usepackage{MnSymbol}           % Symbols
\usepackage{wasysym}            % Symbols
%\usepackage[english,german,french,spanish,italian]{babel}              % Languages

% Document Info
\author{Nouha\_Thabet}
\pdfinfo{
  /Title (awk-part-2.pdf)
  /Creator (Cheatography)
  /Author (Nouha\_Thabet)
  /Subject (AWK - Part 2 Cheat Sheet)
}

% Lengths and widths
\addtolength{\textwidth}{6cm}
\addtolength{\textheight}{-1cm}
\addtolength{\hoffset}{-3cm}
\addtolength{\voffset}{-2cm}
\setlength{\tabcolsep}{0.2cm} % Space between columns
\setlength{\headsep}{-12pt} % Reduce space between header and content
\setlength{\headheight}{85pt} % If less, LaTeX automatically increases it
\renewcommand{\footrulewidth}{0pt} % Remove footer line
\renewcommand{\headrulewidth}{0pt} % Remove header line
\renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit
% This two commands together give roughly
% the right line height in the tables
\renewcommand{\arraystretch}{1.3}
\onehalfspacing

% Commands
\newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour
\newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols
\newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns
\newcommand{\tn}{\tabularnewline} % Required as custom column type in use

% Font and Colours
\definecolor{HeadBackground}{HTML}{333333}
\definecolor{FootBackground}{HTML}{666666}
\definecolor{TextColor}{HTML}{333333}
\definecolor{DarkBackground}{HTML}{933BB3}
\definecolor{LightBackground}{HTML}{F8F2FA}
\renewcommand{\familydefault}{\sfdefault}
\color{TextColor}

% Header and Footer
\pagestyle{fancy}
\fancyhead{} % Set header to blank
\fancyfoot{} % Set footer to blank
\fancyhead[L]{
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{C}
    \SetRowColor{DarkBackground}
    \vspace{-7pt}
    {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent
        \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}}
    }
\end{tabulary}
\columnbreak
\begin{tabulary}{11cm}{L}
    \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{AWK - Part 2 Cheat Sheet}}}} \\
    \normalsize{by \textcolor{DarkBackground}{Nouha\_Thabet} via \textcolor{DarkBackground}{\uline{cheatography.com/103894/cs/21387/}}}
\end{tabulary}
\end{multicols}}

\fancyfoot[L]{ \footnotesize
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{LL}
  \SetRowColor{FootBackground}
  \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}}  \\
  \vspace{-2pt}Nouha\_Thabet \\
  \uline{cheatography.com/nouha-thabet} \\
  \end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}}  \\
   \vspace{-2pt}Not Yet Published.\\
   Updated 12th December, 2019.\\
   Page {\thepage} of \pageref{LastPage}.
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}}  \\
  \SetRowColor{white}
  \vspace{-5pt}
  %\includegraphics[width=48px,height=48px]{dave.jpeg}
  Measure your website readability!\\
  www.readability-score.com
\end{tabulary}
\end{multicols}}




\begin{document}
\raggedright
\raggedcolumns

% Set font size to small. Switch to any value
% from this page to resize cheat sheet text:
% www.emerson.emory.edu/services/latex/latex_169.html
\footnotesize % Small font.

\begin{multicols*}{3}

\begin{tabularx}{5.377cm}{p{0.4977 cm} p{0.4977 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Print lines that contain a specific field}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{Let take the file awk.txt as an example:} \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{AWK is awesome \{\{nl\}\}Let learn AWK together \{\{nl\}\} AWK is used for text processing} \tn 
% Row Count 3 (+ 2)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{We want to print lines that contain the word "is":} \tn 
% Row Count 4 (+ 1)
% Row 3
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{`awk '/is/ \{print \$0\}' \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} AWK is awesome \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} AWK is used for text processing`} \tn 
% Row Count 6 (+ 2)
% Row 4
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{What if we want to specify more than one  field and print lines that contain the one of the these fields? \{\{nl\}\} Let choose the fields "is" and "text", and let print "IS" before the line that contains the field "is" and print "TEXT" before the line that contains the field "text". Let see the example:} \tn 
% Row Count 13 (+ 7)
% Row 5
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{`awk '/is/ \{print "IS:", \$0\} /text/ \{print "TEXT:", \$0\}' awk.txt \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} IS: AWK is awesome \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} IS: AWK is used for text processing \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} TEXT: AWK is used for text processing`} \tn 
% Row Count 17 (+ 4)
% Row 6
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{Here we see that the last line was printed twice because it contains the two fields.} \tn 
% Row Count 19 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{p{0.4977 cm} p{0.4977 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{awk -f}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{The f flag specifies that the following argument is the name of a file that contains an AWK program. Let use the file "command" as an example:} \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{`cat command \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} \{print \$0\}`} \tn 
% Row Count 4 (+ 1)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{We use f flag to tell AWK to execute this pogram on awk.txt and we get the following result:} \tn 
% Row Count 6 (+ 2)
% Row 3
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{`awk -f command awk.txt \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} AWK is awesome \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} Let learn AWK together \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} AWK is used for text processing `} \tn 
% Row Count 9 (+ 3)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{p{0.4977 cm} p{0.4977 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{awk -F}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{The -F flag tell AWK to use the indicated argument as a field seperator. For example if we have fields separated by comma, then we need to specify the field separator.} \tn 
% Row Count 4 (+ 4)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{`awk -F , '\{print \$2\}' \{\{nl\}\} Yellow,Blue,Red \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} Blue`} \tn 
% Row Count 6 (+ 2)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{We use `t` for tab separator.} \tn 
% Row Count 7 (+ 1)
% Row 3
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{In this code `awk -F '{[},!{]}'` "," and "!" are fields seperators.} \tn 
% Row Count 9 (+ 2)
% Row 4
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{In this code "Hello" is a field seperator  `awk -F Hello`} \tn 
% Row Count 11 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{p{0.4977 cm} p{0.4977 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{awk -v}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{The -v flag is used to specify the value of an AWK variable:} \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{`awk -v T = "Tutorial:" '\{print T,\$0\}' awk.txt \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} Tutorial: AWK is awesome \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} Tutorial: Let learn AWK together \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} Tutorial: AWK is used for text processing`} \tn 
% Row Count 6 (+ 4)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{p{0.4977 cm} p{0.4977 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{awk Input}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{As we've already seen we can specify an input file for the awk command, but we can also specify more than one file at the same time :} \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{`awk '\{print \$0\}' file1.txt file2.txt`} \tn 
% Row Count 4 (+ 1)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{We can also ommit the input file. In this case AWK will read from the input in the command line. We can use several inputs and then tape Ctrl+D to exit or (Ctrl+Z in Windows):} \tn 
% Row Count 8 (+ 4)
% Row 3
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{`awk '\{print \$0\}' \{\{nl\}\} one two three \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} two \{\{nl\}\} Yellow Blue Red \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} Blue`} \tn 
% Row Count 10 (+ 2)
% Row 4
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{We can also specify the input from a file:} \tn 
% Row Count 11 (+ 1)
% Row 5
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{`awk '\{print \$0\} \textless{} file.txt`} \tn 
% Row Count 12 (+ 1)
% Row 6
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{We can also take an input from a command with a vertical bar. Let try an example with the command `date`:} \tn 
% Row Count 15 (+ 3)
% Row 7
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{`date \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} Thur Sept 12 11:12:05 CEST 2019 \{\{nl\}\} date | awk '\{print \$2\}' \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} Sept`} \tn 
% Row Count 17 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{5.377cm}{p{0.4977 cm} p{0.4977 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{awk Output}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{We can save the output in output.txt:} \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{`awk '\{print \$2\}' awk.txt \textgreater{} out.txt`} \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{5.377cm}}{We can send the output to a program. Let use the command `sort` to sort the output alphabetically:} \tn 
% Row Count 4 (+ 2)
% Row 3
\SetRowColor{white}
\mymulticolumn{2}{x{5.377cm}}{`awk '\{print NF,\$0\}' awk.txt |sort \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} AWK is awesome \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} AWK is used for text processing \{\{nl\}\} \textgreater{}\textgreater{}\textgreater{} Let learn AWK together`} \tn 
% Row Count 7 (+ 3)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}


% That's all folks
\end{multicols*}

\end{document}