problem while adding column values in awk Post: 302338165

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help in adding positive & negative values in a column

Hi Gurus, In my file I have an amount field from position 74 to 87, which contains values starting with '+' as well as '-'. I want to add all positive values in a varible called "CREDIT" and all negative values in a variable "DEBIT". I know, we can use grep to identify values with positive and...

2. Shell Programming and Scripting

How to pick values from column based on key values by usin AWK

Dear Guyz:) I have 2 different input files like this. I would like to pick the values or letters from the inputfile2 based on inputfile1 keys (A,F,N,X,Z). I have done similar task by using awk but in that case the inputfiles are similar like in inputfile2 (all keys in 1st column and values in...

3. Shell Programming and Scripting

for each different entry in column 1 extract maximum values from column 2 in unix/awk

Hello, I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2 SDF4 -0.211654 SDF4 0.978068 ...

4. Shell Programming and Scripting

Adding successive values in awk

Hi, I have a large log file in the following format. Epoch-Time Bytes 899726401 20 899726401 30 899726402 40 899726402 10 899726402 50 899726403 50 899726403 ...

5. UNIX for Dummies Questions & Answers

Adding column with values

Dear all, I need your help for my question please I have without header (space separated) and need to add two colomns at the beginning with values my file look like : rs1 a t 0.6 rs2 a c 0.3 rs3 t g 0.8 I need to a new file like: 1 100 rs1 a t 0.6 1 100 rs2 a c 0.3 1 100 rs3 t g...

6. Shell Programming and Scripting

Adding column values in a file

Hi, I am having a file in the following format. for aaaa 1111 1234 2222 3434 for bbbb 1111 3434.343 2222 2343 for cccc 3333 2343.343 4444 89000 for dddd 1111 5678.343 2222 890.3 aaaa 2343.343 bbbb 34343.343

7. Shell Programming and Scripting

Adding Column Values Using Pattern Match

Hi All, I have a file with data as below: A,FILE1_MYFILE_20130309_1038,80,25.60 B,FILE1_MYFILE_20130309_1038,24290,18543.38 C,FILE1_dsc_dlk_MYFILE_20130309_1038,3,10.10 A,FILE2_MYFILE_20130310_1039,85,110.10 B,FILE2_MYFILE_20130310_1039,10,12.10...

8. Shell Programming and Scripting

Adding of two column values

Hi cat /tmp/xx.txt 1 4 1 5 1 6 2 1 2 1 2 1 i want to add the values of 2nd column resepect to 1st column values..for 1 in 1st column i need sum of all the values in 2nd column ..pls tell me hw to do it??

9. Shell Programming and Scripting

Adding values of a column based on another column

Hello, I have a data such as this: ENSGALG00000000189 329 G A 4 2 0 ENSGALG00000000189 518 T C 5 1 0 ENSGALG00000000189 1104 G A 5 1 0 ENSGALG00000000187 3687 G T 5 1 0 ENSGALG00000000187 4533 A T 4 2 0 ENSGALG00000000233 5811 T C 4 2 0 ENSGALG00000000233 5998 C A 5 1 0 I want to...

10. Shell Programming and Scripting

awk script to append suffix to column when column has duplicated values

Please help me to get required output for both scenario 1 and scenario 2 and need separate code for both scenario 1 and scenario 2 Scenario 1 i need to do below changes only when column1 is CR and column3 has duplicates rows/values. This inputfile can contain 100 of this duplicated rows of...

LEARN ABOUT DEBIAN

flow-mask

flow-mask(1)						      General Commands Manual						      flow-mask(1)

NAME

       flow-mask -- Apply tags to flow files.

SYNOPSIS

       flow-mask [-hk]	[-b big|little]  [-C comment]  [-d debug_level]  [-m mask_fname]  [-M active_def ...]

DESCRIPTION

       The flow-mask utility is used to modify the source and destination mask length's in flow records.

OPTIONS

       -b big|little
		 Byte order of output.

       -C Comment
		 Add a comment.

       -d debug_level
		 Enable debugging.

       -h	 Display help.

       -k	 Keep time from input.

       -m mask_fname
		 Load masks from mask_name.  Defaults to /etc/flow-tools/cfg/mask

       -M mask_def
		 Use active_def as the active tag definition(s).

       The configuration file is a collection of definitions.  A definition lists a sequence of prefixes and the mask length to replace the match-
       ing prefix with.  Lines begining with # are treated as comments and ignored.

       mask-definition command		   Description
       ----------------------------------------------------------------------
       mask-definition			   Begin mask-definition section
					   mask-definition foo

       prefix				   List the prefix to match on and the
					   replacement mask.
					   prefix 128.146/16 24

EXAMPLES

       #
       #file: masks
       #
       mask-definition foo
       # All networks in 128.146/16 are /24's.
	prefix 128.146/16 24
       # except for 128.146.214/24, which are /32's.
	prefix 128.146.214/24 32

       flow-cat flows | flow-mask -mfoo -Fmasks | flow-print -f4

FILES

	 Configuration files:
	   Mask - /etc/flow-tools/cfg/mask.cfg.

BUGS

       None known.

AUTHOR

       Mark Fullmer maf@splintered.net

SEE ALSO

       flow-tools(1)

																      flow-mask(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help in adding positive & negative values in a column

Discussion started by: berlin_germany

2. Shell Programming and Scripting

How to pick values from column based on key values by usin AWK

Discussion started by: repinementer

3. Shell Programming and Scripting

for each different entry in column 1 extract maximum values from column 2 in unix/awk

Discussion started by: Diya123

4. Shell Programming and Scripting

Adding successive values in awk

Discussion started by: sajal.bhatia