|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Help in awk/bash
Post 302750339 by bioinfo on Monday 31st of December 2012 12:52:50 PM
12-31-2012
1st field in o.txt does end with 00.000
Sorry, I did not know that its too critical to include 00.000
Now I checked manually in all my files, except one value which is 5390.001, all other ends with .000
As you suggested a good point, (even I have not thought of it
) regarding value 19,824.80 and three options:
(1) nothing to be printed,
(2) result of the division truncated to return the 19,824th entry, or
(3) rounded to return the 19,825th entry
So, I wish to retreive both entries 19,824th and 19,825 in one file as well as 3 other files with above options.
That means for 1st field values that are non-divisible by 100, I wish to retreive one file containing nothing for them, one file with truncated, one file with rounded and fourth file with both truncated and rounded values (but each of these 4 files must have divisible entries too).
Thanks
Sorry, I did not know that its too critical to include 00.000
Now I checked manually in all my files, except one value which is 5390.001, all other ends with .000
As you suggested a good point, (even I have not thought of it
) regarding value 19,824.80 and three options:(1) nothing to be printed,
(2) result of the division truncated to return the 19,824th entry, or
(3) rounded to return the 19,825th entry
So, I wish to retreive both entries 19,824th and 19,825 in one file as well as 3 other files with above options.
That means for 1st field values that are non-divisible by 100, I wish to retreive one file containing nothing for them, one file with truncated, one file with rounded and fourth file with both truncated and rounded values (but each of these 4 files must have divisible entries too).
Thanks
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I have a file.txt with 20000 lines and 2 columns each which consists of current_filename and new_filename . I want to create a script to find files in a directory with current_filename and move it to new folder with new_filename.
Could you please help me how to do that??
... (2 Replies)
Discussion started by: narasimhulu
2 Replies
2. Shell Programming and Scripting
Hi,
I have a file which is:-
1 6 4 8 2 3
2 1 9 3 2 1
3 3 5 6 3 1
4 9 7 8 2 3
I would like to sort from field $2 to field $6 for each of the line to:-
1 2 3 4 6 8
2 1 1 2 3 9
3 1 3 3 5 6
4 2 3 7 8 9
I came across this Arrays on example 26-6. But it is much complicated. I am... (7 Replies)
Discussion started by: ahjiefreak
7 Replies
3. Shell Programming and Scripting
Hi,
I'm trying to read a file containing lines with spaces in them.
The inputfile looks like this
------------------------------
Command1 arg1 arg2
Command2 arg5 arg6 arg7
-------------------------------
The shell code looks like this...
lines=`awk '{ print }' inputfile`
... (2 Replies)
Discussion started by: a-gopal
2 Replies
4. Shell Programming and Scripting
I'm trying to reformat some tide information into a useable format and failing.
Input file is....
4452 CHENNAI (MADRAS)
13°06'N, 80°18'E India East Coast 01 June 2009 UT(GMT)
Data Area 3. Indian Ocean (northern part) and Red Sea to Singapore
01/06/2009
00:00 0.7 m
00:20 0.7 m
00:40... (3 Replies)
Discussion started by: garethsays
3 Replies
5. UNIX for Dummies Questions & Answers
Hi Everyone,
I have an input file in the following format:
score.file1.txt
contig00045 length=566 numreads=19 1047 0.0
contig00055 length=524 numreads=7 793 0.0
contig00052 length=535 numreads=10 607 e-176
contig00072 length=472 numreads=46 571 e-165... (8 Replies)
Discussion started by: Fahmida
8 Replies
6. Shell Programming and Scripting
I would like to write a script to extend this command to a general case:
BEGIN {s_0=0;n_0=0}{n_0++;s_0+=($51-$1)^2}END {print sqrt(s_0/n_0)}
i.e. so that
BEGIN {s_0=0;n_0=0}{n_0++;s_0+=($51-$1)^2}END {print sqrt(s_0/n_0)}
BEGIN {s_1=0;n_1=0}{n_1++;s_1+=($51-$2)^2}END {print... (3 Replies)
Discussion started by: chrisjorg
3 Replies
7. UNIX for Dummies Questions & Answers
Hi, I am also a newbie in awk and trying to find solution of my problem.
I have one reference file 1.txt with 2 columns and I want to search other 10 files (a.txt, b.txt......h.txt each with 5 columns) corresponding to the values of 2nd column from 1.txt. If the value from 2nd column from 1.txt... (0 Replies)
Discussion started by: bioinfo
0 Replies
8. Shell Programming and Scripting
Hi, I have two files: atom.txt and g.txt
atom.txt has multiple patterns but I am showing only two patterns each ending with ENDMDL:
ATOM 1 N SER A 1 35.092 83.194 140.076 1.00 0.00 N
ATOM 2 CA SER A 1 35.216 83.725 138.725 1.00 0.00 C
TER
ENDMDL
ATOM 1 N SER A 1 35.683 81.326 139.778 1.00... (11 Replies)
Discussion started by: bioinfo
11 Replies
9. Shell Programming and Scripting
Hi
I am a newbie starting bash and I have a simple need to return the result of an operation from awk to bash. basically I want to use awk to tell me if "#" exists in a string, and then back in bash, i want to do an IF statement on this return in order to do other things. In my bash shell I... (2 Replies)
Discussion started by: oahmad
2 Replies
10. UNIX for Dummies Questions & Answers
Hi!
I have a new problem with awk, this time I think is because I'm using it in bash and I don't know how to put the valor of the variable in awk. Here is the code:
#!/bin/bash
for i in 1 2 3 4 5
do
a=$i
b=$
awk '$1>=a&&$1<=b {print $1,$2,$3}'>asdf test... (3 Replies)
Discussion started by: florpi
3 Replies