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:
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:
Any help with that would be greatly appreciated.
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 ----------
Did you copy paste what I gave you literally? The adaptation you tried last time needed a lot of work. Show what you actually did.
It'd also help to know what your system is.
I have no idea why it works with nawk but not awk. I tried it on the 'worst' version of awk I have available myself; as far as I know I did nothing that needed nawk.
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)
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)
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)
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)
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)
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)
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)
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)
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)