Sponsored Content
Top Forums Shell Programming and Scripting Enter third column & Perform Operation Post 302530258 by Corona688 on Monday 13th of June 2011 11:20:49 AM
Old 06-13-2011
I don't know why you kept -v when you didn't keep all the stuff it's for.

I'm having a hard time telling what you want to do with this code. I tried to show you how to move the expr into awk (where it belongs) but you've just added more of them. (Half of them with incorrect syntax that's probably throwing errors all by itself.) What're all the expr's for? What're you actually trying to do?

---------- Post updated at 09:20 AM ---------- Previous update was at 09:12 AM ----------

Quote:
Originally Posted by Ernst
Can someone tell me what's wrong with this code?

Code:
#!/usr/bin/ksh
echo Enter a value for p
read p
a=16384
b=1228800
c=2914
expr $c '*' $c > e
expr $a/$b > x
cat e | expr $x/$e > y
expr $p '*' $y > d
awk -v '{ print $1, $2, ($2*d); }' addcolumn > add.xls

Taking your code at face value:
Code:
read p
awk -v a=16384 -v b=1228800 -v c=2914 -v p="$p" '
BEGIN {
        e=c*c;
        x=a/b;
        y=x/e;
        d=p*y;
        }
{
        print $1, $2, ($2*d);
}' addcolumn > add.xls

 

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. (4 Replies)
Discussion started by: agathaeleanor
4 Replies

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 Replies)
Discussion started by: shashi792
3 Replies

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 Replies)
Discussion started by: shashi792
4 Replies

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... (0 Replies)
Discussion started by: Blue Solo
0 Replies

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 (2 Replies)
Discussion started by: bbc17484
2 Replies

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... (1 Reply)
Discussion started by: karimkhan
1 Replies

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... (4 Replies)
Discussion started by: angshuman
4 Replies

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... (12 Replies)
Discussion started by: Zooma
12 Replies

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... (4 Replies)
Discussion started by: as7951
4 Replies

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... (6 Replies)
Discussion started by: SaPa
6 Replies
test(1) 						      General Commands Manual							   test(1)

Name
       test - test conditional expression

Syntax
       test expr
       [ expr ]

Description
       The  command  evaluates the expression expr.  If the value of expr is true, the command returns a zero exit status; otherwise, it returns a
       nonzero exit status.  The command also returns a nonzero exit status if no arguments are specified.

Options
       The following primitives are used to construct expr:

       -r file		   Tests if the file exists and is readable.

       -w file		   Tests if the file exists and is writable.

       -f file		   Tests if the file exists and is not a directory.

       -d file		   Tests if the file exists and is a directory.

       -s file		   Tests if the file exists and has a size greater than zero.

       -t [ fildes ]	   Tests if the open file, whose file descriptor number is fildes (1 by default), is associated with a terminal device.

       -z s1		   Tests if the length of string s1 is zero.

       -n s1		   Tests if the length of the string s1 is nonzero.

       s1 = s2		   Tests if the strings s1 and s2 are equal.

       s1 != s2 	   Tests if the strings s1 and s2 are not equal.

       s1		   Tests if s1 is not the null string.

       n1 -eq n2	   Tests if number1 equals number2.

       n1 -ge n2	   Tests if number1 is greater than or equal to number2.

       n1 -gt n2	   Tests if number1 is greater than number2.

       n1 -le n2	   Tests if number1 is less than or equal to number2.

       n1 -lt n2	   Tests if number1 is less than number2.

       n1 -ne n2	   Tests if number1 is not equal to number2.

       These primitives can be combined with the following operators:

       !expr		   Negates evaluation of expression.

       expr -a expr	   Tests logical and of two expressions.

       expr -o expr	   Tests logical or of two expressions.

       ( expr... )	   Groups expressions.

       The -a operator takes precedence over the -o operator.  Note that all the operators and flags are separate  arguments  to  Note	also  that
       parentheses are meaningful to the Shell and must be escaped.

See Also
       find(1), sh(1), test(1sh5)

																	   test(1)
All times are GMT -4. The time now is 11:10 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy