Advertisements My understanding of Regex’s in AWK is that in order to match a Regex metacharacter literally (For example: +,$,^,*,etc) You must escape them, like so: awk -F ‘\\+’ ‘program here’ However I’ve noticed that you don’t actually need to do this with certain metacharacters, such as the "+" Input file: this|is|a|line this+is+a+line this?is?a?line this*is*a*line… Read More Matching a regex metacharacter literally

Advertisements I have below CSV file: CreateDate, First Name, Last Name, Description 2023/03/25, Makvala, Anima, Your orders are 6157 and total value is 854257 2023/03/26, Leobwin, Saturnus, Your orders are 72 and total value is 1575675 2023/03/25, Boadicea, Pradip, Your orders are 52116 and total value is 29344357 I want below output Orders: 6157, Total… Read More AWK script to print a single next word following a pattern match from Description field

Advertisements I am trying to use awk and if else statements simultaneously. Expression in if else statements are evaluated to a whole number and giving wrong output. I tried this awk ‘{if ($4/$3 < 0.35) print "reverse"; else if ($3/$4 < 0..35) print "forward"; else print "unstranded" }’ <<< "0 207212663 6541998518 259487717" This is… Read More awk condition with decimal output in if else statement

Advertisements A multi-line variable LOG_BUF is set in a bash script parse.sh. Then the variable is parsed with awk, printing all rows containing pat: #!/bin/bash LOG_BUF=$(cat <<-END pat TEST_a pat TEST_b TEST_c pat TEST_d END ) echo ${LOG_BUF} | awk ‘BEGIN{}; /pat/{printf("%d %s", NR, $0); printf("\n")}; END{printf("\n")}’ The expected output is: $ ./parse.sh 1 mem… Read More How to parse each line separately with awk?

Advertisements I have searched everywhere but couldn’t quite find the exact similar solution to my problem. In Bash, I have a file that is tab delimited. It can potentially have several million lines. In the 27th column there is a string of colors which is delimited by a forward slash. My end goal is for… Read More Taking Substring from Column to grab text until 3rd occurrence of '/'

Advertisements I have a csv file and bash script but it does not work as needed The script #!/bin/bash #create path to redirect accounts.csv to same directory as accounts_new.csv path=$(dirname $1) awk ‘ BEGIN { FS="\""; OFS="," } # input is delimited by double qutoes NR==1 { print; next } { line="" for (i=1;i<NF;i+=2) {… Read More Bash script Find Duplicate Values in CSV file

Advertisements I’m writing a one-liner using awk to join strings within a loop. Basically, there’s an array of strings (I call it a), then I have another copy of that array (I call it b which is cloned using the clone function). I concatenate the string from array a (which is m) and b (which… Read More Join string within loop using awk (involve replacing an array with another)

Advertisements I am trying to argument processing on awk. It works fine if I have no body in it: PK@rhel8:~/tmp-> cat testARG.awk #!/usr/bin/awk -f BEGIN{ argc = ARGC ; CmdName = ARGV[0] ; FirstArg = ARGV[1] printf("Argument count = %d; command name = %s; first argument = %s\n",argc,CmdName,FirstArg) ; } #{ # printf("Argument count =… Read More Cannot use Awk with arguments

Advertisements I’ve got a file that looks like this: a 12345 b 3456 c 45678 and i’ve got bash array of strings: mylist=("a" "b") What I want to do is to sum numbers in second column but only for rows where first column value (aka "a" or "b") is present in mylist. My not-working code:… Read More How to check if string is present in bash array using awk

Advertisements Given files test1 and test2: $ cat test* alert_name,id,severity bar,2,1 foo,1,0 alert_name,id,severity foo,1,9 bar,2,1 I want to find rows where name is the same but severity has changed (ie foo) and print the change. I have got this far using awk: awk ‘BEGIN{FS=","} FNR>1 && NR==FNR { a[$1]; next } ($1 in a) &&… Read More Print rows where one column is the same but another is different