Bash - auto-mate/CheatSheetWiki GitHub Wiki

awk 'BEGIN {FS=" "} $1 !~ /e/ {print $1}' Documents/somedata.txt  

 awk 'BEGIN {FS=" "; print "FILE START";} $1 !~ /e/ {print $1;} \
      END { print "FILE END";}' Documents/somedata.txt  

 awk 'BEGIN {FS=" "; print "FILE START"}  {if ($1 == "ping") {print "YES > "$1} \
 else {print "NO > "$1} } END { print "FILE END"}'  Documents/somedata.txt  

 awk 'function n(v)  { x = length(v); return x } ; \  
 BEGIN { FS=" "; print "FILE START";}  {print n($1)":"$1;}  \  
 END { print "FILE END"}' documents/writelog.bat  

 awk 'myVar = 2; { for ( i = 0; i < 5; i++)  { print myVar i  ; myVar++; } }'  

{ gsub(/Britain/, "United Kingdom"); print } # global sub via regex    
{ print length(x) ;}  # len of string  
split("cul-de-sac", a, "-", seps)  # puts split items in array a[n] "-" into array seps[n]  
sub(/at/, "ith", str) # one sub  
substr(string, 3, 3)  # substring  

# AWK PROGRAM TO CONVERT | DELIMITED FILE TO SQL INSERT STATEMENTS  
##################################################################  

# strings are trimmed and values have commas removed plus dates are reformated

# Main Functions
################
function nullStr(a)   { if(trim(a) == "") b="NULL";else b="'"clean(trim(a))"'"; return b }                                # rtn NULL or trimStr  
function nullVal(a)   { if(trim(a) == "" || length(trim(a)) == 0 ) b="NULL";else b=remComma(trim(a)); return b }          # rtn NULL or trimVal  
function sqlDate(a)   { if(trim(a) == "") b="NULL";else b="'"substr(a,7,4)"-"substr(a,4,2)"-"substr(a,1,2)"'"; return b } # rtn NULL or reform date  

# Sub Functions  
###############  
function clean(s)     { gsub(/'/, " ", s); return s }              # 
function ltrim(s)     { sub(/^[ \s\t\r\n]+/, "", s); return s }    # left  trims s
function rtrim(s)     { sub(/[ \s\t\r\n]+$/, "", s); return s }    # right trims s
function trim(s)      { return rtrim(ltrim(s)); }                  # whole trim  s
function remComma(s)  { gsub(/,/,"",s); if(s ~ /-/) {sub(/-/,"",s);return "-"s;} else return s ;}  # removes commas


# Main Program Converts Data to SQL Clear and Insert file  
#########################################################  
BEGIN {FS="|"; print "USE <DB_NAME>;\nGO\nDELETE FROM [<TABLE_NAME>];\n"} # FS = Field Separator NB RS is Record Separator 
#START File Process  
###################  
/^\|\s|\|[0-9]/ {print "BEGIN TRY" # For Any Line that starts "| " OR "|" then a number Begin Try is an SQL statement  
 print "INSERT INTO [<TABLE_NAME>] ";  
 print "( " ;  
 print "[<fieldName1>],[<fieldName2>],....[<fieldName(n)>],updated"; # where updated is a timestamp field  
 print ") VALUES (";  
 print nullStr( $3)","nullVal( $4)","sqlDate($15)",.....,'"strftime("%Y-%m-%d %H:%M:%S",systime())"'"; # Note calc of updated  
 print ") END TRY";     # End Try       is an SQL statement  
 print "BEGIN CATCH";   # Begin Catch   is an SQL statement  
 print "print 'error'"; # print 'error' is an SQL statement   
 print "END CATCH";     # End Catch     is an SQL statement  
}