AWK solution to subtract multiple columns of numbers Post: 302277827

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to subtract a number from all columns?

Hi, I want to subtract a number from all columns except the first column. I have a number of files each having different columns around 60/70. How to do that in awk or any other command? Thanks Input Col 1 Col 2 Col3 - - - - Col55 1 .0123 .098 - - - 0.6728 2 - -...

2. Shell Programming and Scripting

Awk match multiple columns in multiple lines in single file

Hi, Input 7488 7389 chr1.fa chr1.fa 3546 9887 chr5.fa chr9.fa 7387 7898 chrX.fa chr3.fa 7488 7389 chr21.fa chr3.fa 7488 7389 chr1.fa chr1.fa 3546 9887 chr9.fa chr5.fa 7898 7387 chrX.fa chr3.fa Desired Output 7488 7389 chr1.fa chr1.fa 2 3546 9887 chr5.fa chr9.fa 2...

3. Shell Programming and Scripting

Help need to subtract the data from 2 columns

space_used.lst /dev/vx/dsk/A06487-S01-c4e3s-ORACLE-dg/oradata01 505G 318G 175G 65% /dborafiles/nethealth21/PV/oradata01 /dev/vx/dsk/A06487-S01-c4e3s-ORACLE-dg/oradata02 505G 433G 67G 87% /dborafiles/nethealth21/PV/oradata02 /dev/vx/dsk/A06487-S01-c4e3s-ORACLE-dg/oradata03 507G 422G 79G 85%...

4. Shell Programming and Scripting

Any solution with awk for volatile columns??

Hi I have this file with content ale,4 ,ale,2 ,ale,1 ,ale,2 ale,1 ,ale,7 ,ale,7 ,ale,13 ale,6 ,ale,1 ,ale,1 ,ale,1 ale,1 ,ale,1 ,ale,37 ,ale,1 ale,1 ,ale,1 ,ale,2 ,ale,37 ale,77 ,ale,1 ,ale,53 ,ale,3 ale,5 ,ale,1 ,ale,2 ,ale,40 ale,1 ,ale,1 ,ale,44 ,ale,1...

5. Shell Programming and Scripting

Add values in 2 columns and subtract from third

Hi All, I have a file with thousands of lines in the following format, where Field1=First 8 characters Field2-9-16 characters Field3=17-26 characters I need to add Field 1 and Field2 and subtract the result from Field 3. Field3=Field3 - (Field1 + Field2) 0012.00 0010.00 0001576.53...

6. UNIX for Dummies Questions & Answers

[Solved] awk solution to add sequential numbers based on a word

Hi experts, I've been struggling to format a large genetic dataset. It's complicated to explain so I'll simply post example input/output $cat input.txt ID GENE pos start end blah1 coolgene 1 3 5 blah2 coolgene 1 4 6 blah3 coolgene 1 4 ...

7. UNIX for Dummies Questions & Answers

awk to add/subtract an integer to/from each entry in columns?

---------- Post updated at 01:58 PM ---------- Previous update was at 01:48 PM ---------- For some reason my question is not getting printed. Here are the details: Greetings. I would like to add/subtact an integer to/from two columns of integers. I feel like this should be easy using awk...

8. UNIX for Dummies Questions & Answers

Help with awk solution to add columns

Hi all. Wondering if someone can help with an awk solution to a problem I'm stumped with. I have a matrix file with >1000 fields and would like to add another column after each column with a text label. For example: Input: $cat file.txt name col1 col2 col3 coln aaaa ...

9. 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...

10. Shell Programming and Scripting

Please help - Command to Subtract two numbers without losing prefix zeros

Hello, I have a variable LOGNUM with values 0000095, When i subtract the variable by 1, Its losing its leading zeros. Can you please help me here ? LOGNUM=0000095 $OLDLOG=`echo "${LOGNUM}-1"|bc` $ echo $OLDLOG 94 Am expecting output as 0000094 Appreciate your help! Thanks,...

LEARN ABOUT DEBIAN

purity-ng

PURITY-NG(6)							   Games Manual 						      PURITY-NG(6)

NAME

       purity-ng - general purpose purity testing software

SYNOPSIS

       purity-ng [OPTION]...  list|FILE|TESTNAME

DESCRIPTION

       Purity  is  an  interactive purity test program with a simple, user interface and datafile format.  For each test, questions are printed to
       the your terminal, and you are prompted for an answer to the current question.  At a prompt, these are your choices:

	      y      Answer "yes" to the question.
	      n      Answer "no" to the question.
	      b      Backup  one  question, if you answered it incorrectly, or someone is watching you take the test, and you don't (or do) want to admit a different answer.
	      s      Print your current score on the test you are taking.
	      q      Quit the test, and print the current score.
	      ?      Print a help screen for the current prompt.

       At the end of the test, your score is printed out.  For most purity tests, lower scores denote more "experience" of the test material.

OPTIONS

       --version
	      print current version of purity-ng

       -h, --help
	      show the help message and exit

       -p     print the test without prompting for answers.

       -r     decrypt the test using the Rot 13 algorithm.

       To get a list of all purity tests available globally on your system, run purity-ng list.

AUTHORS

       purity was originally written by Eric Lechner in 1989.  purity-ng is a reimplementation of purity in Python for modern systems, written	by
       Simon Fondrie-Teitler and Luke Faraone.

       This manual page was written by Luke Faraone.

BUGS

       If you find bugs in the application, please report these to <https://bugs.launchpad.net/purity-ng> or to your distribution's distributor.

SEE ALSO

       purity(6)

       Running purity-ng format provides documentation about the datafile format.

       Additional documentation is available online at <http://packages.python.org/purity-ng>.

								  January 7, 2011						      PURITY-NG(6)