Searching columns and subtracting values in awk Post: 302693767

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

comparing files - adding/subtracting/formating columns

I have two files: file1.txt: FS Total Used Free Used% /u01 10000 8000 2000 80% /u02 10000 8000 2000 80% /u03 10000 8000 2000 80% /u04 10000 8000 2000 80% /u05 10000 8000 2000 80% /u06 10000 8000 2000 80% /u07 10000 8000 2000 80% /u10 10000 5000 5000 50% file2.txt:...

2. Shell Programming and Scripting

Subtracting with awk?

i have a small awk script which prints the 5 columns of different o/p i want the 5th column subtracted from 100 and then display the result .. but i do not get the desired result .. I 'm using following script awk ' BEGIN { FS="" RS="us" } { ...

3. Shell Programming and Scripting

subtracting 1.5 from column using awk and saving the changes

# foreach sub ( sub001 ) sub=sub001 cd /mnt/stor/smith/recog/$sub/event_files/timecorrected/ awk '{$1-1.5}' $sub_CR end What im trying to do is: 1. open a 1D file that consists of lists of integers in rows a columns 2. subtract 1.5 from each integer in the first column 3. save the file...

4. Shell Programming and Scripting

Subtracting columns against each other

Hi All, I have a file of 100 lines of each having 1000 columns. I need to find the difference of each column against each other. That means, Col1-Col1; Col1-Col2; Col1-Col3;......Col1-Col1000; Col2-Col1; Col2-Col2; Col2-Col3;.... and so on ....up to Col1000-Col1000. Lets say the file is...

5. Shell Programming and Scripting

AWK- extracting values from columns, saving them and gettins statistics

Hello, I am obviously quite new to unix and awk. I need to parse certain columns of a file (delimited by spaces), and somehow save the value of this column somewhere, together with the value of the column just after it (by pairs; so something like ). I'm then supposed to count the times that...

6. UNIX for Dummies Questions & Answers

Subtracting values from 2 columns in a file

Hello, I have a file with 5 columns that looks like this: A1BG chr19 + 58863335 58866549 A1BG chr19 - 58858171 58864865 A2LD1 chr13 - 101182417 101186056 A2LD1 chr13 - 101182417 101241046 A2M chr12 - 9220303 9268558 A2ML1 ...

7. Shell Programming and Scripting

Subtracting values from variable

Legends, Please help me in , how do i subtract the variable values listed like below. the first value of orig should be subtracted from first value of prev and so on. san> echo $orig 346 316 340 239 410 107 291 139 128 230 167 147 159 159 172 116 110 260 177 0 177 169 168 186 165 366 195...

8. Shell Programming and Scripting

awk - Adding and Subtracting Numbers from 2 Columns

Hi Folks, I have a file with 2 columns TAB delimited and I want to add '1' to the first column and subtract '-1' from the second column. What I have tried so far is; awk -F"\t" '{ $1-=1;$2+=1}1' OFS='\t' file File 0623 0623 0624 0624 0643 0643 1059 1037 1037 1037 1038 1038...

9. Shell Programming and Scripting

Do replace operation and awk to sum multiple columns if another column has duplicate values

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For...

10. UNIX for Beginners Questions & Answers

Awk: compare values in two columns of the same file

I'm trying to learn awk, but I've hit a roadblock with this problem. I have a hierarchy stored in a file with 3 columns: id name parentID 4 D 2 2 B 1 3 C 1 1 A 5 I need to check if there are any values in column 3 that are not represented anywhere in column 1. I've tried this: awk '{arr;}...

LEARN ABOUT FREEBSD

zcmp

ZDIFF(1)						    BSD General Commands Manual 						  ZDIFF(1)

NAME

     zcmp, zdiff -- compare compressed files

SYNOPSIS

     zcmp [options] file [file2]
     zdiff [options] file [file2]

DESCRIPTION

     zcmp and zdiff are filters that invoke cmp(1) or diff(1) respectively to compare compressed files.  Any options that are specified are passed
     to cmp(1) or diff(1).

     If only file1 is specified, it is compared against a file with the same name, but with the extension removed.  When both file1 or file2 are
     specified, either file may be compressed.

     Extensions handled by gzip(1):
     o	 z, Z,
     o	 gz,
     o	 taz,
     o	 tgz.

     Extensions handled by bzip2(1):
     o	 bz,
     o	 bz2,
     o	 tbz,
     o	 tbz2.

     Extensions handled by xz(1):
     o	 lzma,
     o	 xz,
     o	 tlz,
     o	 txz.

ENVIRONMENT

     TMPDIR  Directory in which to place temporary files.  If unset, /tmp is used.

FILES

     /tmp/zcmp.XXXXXXXXXX   Temporary file for zcmp.
     /tmp/zdiff.XXXXXXXXXX  Temporary file for zdiff.

SEE ALSO

     bzip2(1), cmp(1), diff(1), gzip(1), xz(1)

CAVEATS

     zcmp and zdiff rely solely on the file extension to determine what is, or is not, a compressed file.  Consequently, the following are not
     supported as arguments:

     -	 directories

     -	 device special files

     -	 filenames indicating the standard input (``-'')

BSD
								   May 23, 2011 							       BSD

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

comparing files - adding/subtracting/formating columns

Discussion started by: oabdalla

2. Shell Programming and Scripting

Subtracting with awk?

Discussion started by: fugitive

3. Shell Programming and Scripting

subtracting 1.5 from column using awk and saving the changes

Discussion started by: ac130pilot

4. Shell Programming and Scripting

Subtracting columns against each other

Discussion started by: Fredrick