Enter third column & Perform Operation Post: 302529856

Sponsored Content

Top Forums Shell Programming and Scripting Enter third column & Perform Operation Post 302529856 by Ernst on Friday 10th of June 2011 04:58:22 PM

06-10-2011

Registered User

Enter third column & Perform Operation

I am trying to enter a third column in this file, but the third column should that I call "Math" perform a some math calculations based on the value found in column #2.
Here is the input file:

Quote:

GERk0203078$ Levir
Cotete_1 84412351
Cotete_2 39308596
Cotete_3 39393962

GERk0203040$ Levir
Cotete_1 37235657
Cotete_2 84227986
Cotete_3 30187827

GERk0203050$ Levir
Cotete_1 37217582
Cotete_2 30317038
Cotete_3 30100170

Here is the desired output:
Output
GERk0203078$ Levir Math
Cotete_1 84412351 (Value of Levir * Constant)/ constant
Cotete_2 39308596 (Value of Levir * Constant)/ constant
Cotete_3 39393962 (Value of Levir * Constant)/ constant

GERk0203040$ Levir
Cotete_1 37235657 (Value of Levir * Constant)/ constant
Cotete_2 84227986 (Value of Levir * Constant)/ constant
Cotete_3 30187827 (Value of Levir * Constant)/ constant

GERk0203050$ Levir
Cotete_1 37217582 (Value of Levir * Constant)/ constant
Cotete_2 30317038 (Value of Levir * Constant)/ constant
Cotete_3 3010017 (Value of Levir * Constant)/ constant

I started this script but not sure how to get the value from column Levir:

Code:

#!/usr/bin/ksh
#a is the first constant
#b is the second constant
a=75
b=2500
awk 'NR<=$a {print $1, $2, ("Math" )}' addcolumn > addcolumn.xls
expr ($Levir '*$a') / $b

Any help with that would be greatly appreciated.

Ernst

View Public Profile for Ernst

Find all posts by Ernst

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to perform arithmetic operation on date

Hi all, I would appreciate if anyone knows how to perform adding to date. As for normal date, i can easily plus with any number. But when it comes to month end say for example 28 Jun, i need to perform a plus with number 3, it will not return 1 Jul. Thanks in advance for your help.

2. Shell Programming and Scripting

perform some operation on a specific coulmn starting from a specific line

I have a txt file having rows and coulmns, i want to perform some operation on a specific coulmn starting from a specific line. eg: 50.000000 1 1 1 1000.00000 1000.00000 50000.000 19 19 3.69797533E-07 871.66394 ...

3. Shell Programming and Scripting

Column operation : cosne and sine operation

I have a txt file with several columns and i want to peform an operation on two columns and output it to a new txt file . file.txt 900.00000 1 1 1 500.00000 500.00000 100000.000 4 4 1.45257346E-07 899.10834 ...

4. Shell Programming and Scripting

[Solved] Perform an operation to all directories

Sorry, about this thread - I solved my own problem! Thanks for taking a look. edit by bakunin: no problem, but it would have been a nice touch to actually tell us what the solution was. This would have been slightlich more educating than just knowing that you found it. I changed your title to...

5. Shell Programming and Scripting

Help me to perform count & group by operation in shell scripting?

Hi All, I want to display the distinct values in the file and for each distinct value how may occurance or there. Test data: test1.dat 20121105 20121105 20121105 20121105 20121106 20121106 20121106 20121105 I need to display the output like Output

6. Homework & Coursework Questions

Using dbms_pipe with C++ to perform daabase operation

I am getting two result: string and int in c++ code. That I want to store into database. The request which generates result is very frequent. So each time performing db operation to store the result is costly for me. So how this can be achived using dbms_sql? I dont have any experience and how...

7. Shell Programming and Scripting

How To Perform Mathematical Operation Within If in awk?

Hi All, I am using an awk script as below: awk -F'|' 'BEGIN{OFS="|";} { if ($1==$3 && $3==$7 && $7==$13 && $2==$6 && $6==$11 && $15-$14+1==$11) print $0"|""TRUE"; else print $0"|""FALSE"; }' tempfile.txt In above script, all conditions are being checked except the one which is...

8. Shell Programming and Scripting

Filter on one column and then perform conditional calculations on another column with a Linux script

Hi, I have a file (stats.txt) with columns like in the example below. Destination IP address, timestamp, TCP packet sequence number and packet length. destIP time seqNo packetLength 1.2.3.4 0.01 123 500 1.2.3.5 0.03 44 1500 1.3.2.5 0.08 44 1500 1.2.3.4 0.44...

9. Shell Programming and Scripting

awk script to find data in three file and perform replace operation

Have three files. Any other approach with regards to file concatenation or splitting, etc is appreciated If column55(billngtype) of file1 contains YMNC or YPBC then pick the value of column13(documentnumber). Now find this documentnumber in column1(Billdoc) of file2 and grep the corresponding...

10. UNIX for Beginners Questions & Answers

Copy last few lines of a file, perform math operation and iterate further

Hi, I am trying to generate a data of following order: 4 0 1 642 643 4 642 643 1283 1284 4 1283 1284 1924 1925 4 1924 1925 2565 2566 4 2565 2566 3206 3207 4 3206 3207 3847 3848 4 3847 3848 4488 4489 4 4488 4489 5129 5130 ---------------------- 4 1 2 643 644 4 643 644 1284...

LEARN ABOUT OPENSOLARIS

mlib_imageconstmul

mlib_ImageConstMul(3MLIB)				    mediaLib Library Functions					 mlib_ImageConstMul(3MLIB)

NAME

       mlib_ImageConstMul - multiplication with a constant

SYNOPSIS

       cc [ flag... ] file... -lmlib [ library... ]
       #include <mlib.h>

       mlib_status mlib_ImageConstMul(mlib_image *dst, const mlib_image *src,
	    const mlib_d64 *c);

DESCRIPTION

       The mlib_ImageConstMul() function multiplies each pixel in an image by a constant value on a pixel-by-pixel basis.

       It uses the following equation:

	 dst[x][y][i] = c[i] * src[x][y][i]

PARAMETERS

       The function takes the following arguments:

       dst    Pointer to destination image.

       src    Pointer to source image.

       c      Constant by which each pixel is multiplied. c[i] contains the constant for channel i.

RETURN VALUES

       The function returns MLIB_SUCCESS if successful. Otherwise it returns MLIB_FAILURE.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Committed 		   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |MT-Safe			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       mlib_ImageConstMul_Fp(3MLIB),  mlib_ImageConstMul_Fp_Inp(3MLIB), mlib_ImageConstMul_Inp(3MLIB), mlib_ImageConstMulShift(3MLIB), mlib_Image-
       ConstMulShift_Inp(3MLIB), attributes(5)

SunOS 5.11							    2 Mar 2007						 mlib_ImageConstMul(3MLIB)