Advertisements I have text file like below: ID Grade1 Grade2 Grade3 JK01 92 84 88 JK02 87 80 93 JK03 89 98 95 I want to extract specific column then add two column using awk. Weight will from Grade2 *1.5+2,and Note is a specific number:17. Desird Output like: ID Grade2 Weight Note JK01 84 134… Read More How to extract columns then add new column by caculate in Linux

Advertisements I am currently trying to parse some data from bash tables, and I found strange behavior in parsing data if some columns is empty for example i have data like this containerName ipAddress memoryMB name numberOfCpus status ————— ————— ———- ——- ————– ———- TEST_VM 192.168.150.111 8192 TEST_VM 4 POWERED_ON and sometimes like this containerName… Read More Parsing data from bash table with empty fields

Advertisements Here is a test.txt file sometext someothertext … lol 74 hhhhh lol 789AA I want a bash command that only displays: 74 For this I have tried: awk ‘$0 == "lol" {i=1;next};i && i++ <= 1’ test.txt which for now displays 74 789AA So, how can I augment this command so that it only… Read More Awk how to print the next line of a specific expression but only of it contains a number

Advertisements Suppose this file: col1 | | | | | | col2 – – – – col3 this | | | | | | is – – – – good that | | | | | | not – – – – bad I want to print only col1 and col2 for example, but as… Read More How to print the digit number of column in awk

Advertisements This is file1: line1 line2 line3 line4 line5 This is file2: value: line1 id: 12 — value: line3 id: 20 — value: line10 id: 22 — value: line14 id: 8 I want to do this: compare the two files and if the second column of value in file2 doesn’t match the file1, then show… Read More bash loop over two files and one file has two key values

Advertisements This is my file: header 1 (which exists in my original file) col1 col2 col3 name1 1K 1M name2 2M 1K name3 2K 2K name4 2M 2M name5 1K 5M I want to do this: find the third column, if consists of M (megabytes) and (third column * 1024 ** 2 >= 2097152), then… Read More awk if nth column value multiples by X greater than Y

Advertisements Suppose the following columns, delimiter is one space (here for more readability I added more spaces): col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 1 P 0 0 1500 15000 0.5 0.0 200 name1 2 P 0 0 400 5000 0.7 0.2 150 name2 3 R 0 0 2000 2000 0.4 0.1… Read More How to divide two columns with multiple ifs and send output to different files

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