awk logic and math help Post: 302579794

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk math operation on two files

Hi, I need your help. I've got two files and i need to add 2nd line after occurrence of "Group No X" from data2.txt to 3rd line (after occurrence of "Group No X") from data1.txt. There is the same number of "Groups" in both files and the numbers of groups have the same pattern. data1.txt Group...

2. Shell Programming and Scripting

Need help with AWK math

I am trying to do some math, so that I can compare the average of six numbers to a variable. Here is what it looks like (note that when I divide really big numbers, it isn't a real number): $ tail -n 6 named.stats | awk -F\, '{print$1}' 1141804 1140566 1139429 1134210 1084682 895045...

3. Shell Programming and Scripting

awk math and csv output

Hi I have this list 592;1;Z:\WB\DOCS;/FS3_100G/FILER112/BU/MPS/DOCS;;;;\\FILER112\BUMPS-DOCS\;580,116,544,878 Bytes;656,561 ;77,560 592;2;Z:\WB\FOCUS;/FS3_100G/FILER112/BU/MPS/FOCUS;;;;\\FILER112\BUMPS-FOCUS\;172,430 Bytes;6 ;0 ...

4. Shell Programming and Scripting

How to use this logic with awk?

Hi friends, I am having 2 files, I just want to compare 2 files each containing 2 columns 1st column is lat, and 2nd column is long, if anyone can understand below logic please help me in writing script with awk.. here each field of file2 needs to be compared with std_file main counter=0...

5. Shell Programming and Scripting

awk in horizontal and vertical math

Based on input ail,UTT,id1_0,COMBO,21,24,21,19,85 al,UTHAST,id1_0,COMBO,342,390,361,361,1454 and awk code as awk -F, '{ K=0; for(i=NF; i>=(NF-4); i--) { K=K+$i; J=J+$i;} { print K } } END { for ( l in J ) printf("%s ",J); }' I'm trying to add columns and lines in single line. line...

6. Shell Programming and Scripting

awk evaluating a string as a math expression

Hi, I am writing a script in awk trying to replace strings that are math expressions with their result. For example, I have a file that looks like this: 5-1 32/8-1 4*12 17+1-3 I would like to get the following output: 4 3 48 15 I tried doing it the following way (using the "bc"...

7. Shell Programming and Scripting

awk --> math-operation in a array

Hi main object is categorize the difference of data-values (TLUFT02B - TLUFT12B). herefor i read out data-files which are named acording to the timeformat yyyymmddhhmm. WR030B 266.48 Grad 0 WR050B 271.46 Grad 0 WR120B 268.11 Grad 0 WV030B 2.51 m/s ...

8. Shell Programming and Scripting

Count math using awk

Hi expert, I have log : TOTAL-TIME : 2125264636 DATA-BYTES-DOWN : 3766111307032 DATA-BYTES-UP : 455032157567 DL = (3766111307032/2125264636)/1024 = 1.73 UL = (455032157567/2125264636)/1024 = 0.21 I want the result : TOTAL = 1.94 ...

9. Shell Programming and Scripting

Math count %memory using awk

Hi expert, i have log this: Memory: 74410384 Memory: 75831176 Memory: 77961232 Memory: 77074656 Memory: 76086160 Memory: 77128592 Memory: 78045384 Memory: 76696040 Memory: 72401176 Memory: 72520016 Memory: 72137016 Memory: 73175832 Memory: 73034528 Memory: 71770736 Memory:...

10. Shell Programming and Scripting

[awk] Math & Bold-Font?

Heya There is a script which has presets stored in a tab-seperated file. That script also has $help_text, which will be shown when called with invalid arguments or -h. So i do need to have that file ready, so the help text can get the values out of the file, and print it with the $help_text....

LEARN ABOUT CENTOS

tag

tag(3tcl)                                                                                                                                tag(3tcl)

NAME

       tag - Manipulate tagged files

SYNOPSIS

       tag option ?arg arg ...?

DESCRIPTION

       The tag procedure provides a number of options for manipulating tagged files.

COMMANDS

       tag readfile filename

              Reads the file with the given filename and returns a list where each list element is a tag record, which is represented by a list of
              label-value pairs, or label-value-endlabel triples.

              The tag header is the first element returned.

       tag writefile filename list

              Takes a list in the format used internally in tcl programs for tagged data and writes it as a tagged file.

       tag extract list tests

              Takes a list in tagged format, and a list of conditions, and returns a new list in tagged format which contains  those  tag  records
              which match the conditions.

              The tests is a list of test items, each of which is a list of the form { labelname condition matchvalue }

              The conditions are

       ==     String equals

       !=     String not equal

       <=     Less than or equal

       -in    Is the test value a member of the list given as the matchvalue

       -contains
              Does the match value contain the test value as a case insensitive substring.

       -earlier
              Date earlier

       -later Date later - dates are in ISO format (yyyy-mm-dd [hh:mm:ss]).

       -exists
              Does the label exist in this record.

BUGS

       tag readfile reads the whole file into memory before turning it into a list.  Should be more memory efficient.

       The -earlier and -later comparisons require TCL8.3

AUTHOR

       John Lines (john@paladin.demon.co.uk)

                                                                   July 3, 2000                                                          tag(3tcl)