I run it as an awk file on the file that contains the only 2 fields ans I direct the results in new file.
awk -f (your code) (two fieldsFile) > newfile
I got an empty file.......!!!
Ithink there is a miss understanding. I need to print the $2 that relate to 1 in a seperate file and also to print $2 that relates 2 in another seperate file.
File1:
$2 | $8
---------
1.2 | 1
1.3 | 1
.
.
all the values should be with the 1
File2:
$2 | $8
---------
2.2 | 2
1.9 | 2
.
.
---------- Post updated at 05:31 PM ---------- Previous update was at 05:29 PM ----------
I don't want to remove ones or two's---- i want to filter $2 based on them>>>
That's what the code I supplied you does, it dosn't write anything to standard out so no need to redirect this to a file.
Instead, it writes to two files named "ones" and "two" (do a ls in the directory you run the script and they should be there). The remove in the BEGIN block is to just clean up these files if they are still around from a previous run of the script.
Don't know what to tell you, here is a transcript from my test:
Code:
$ cat infile
a 1.351 c d e f g 1 h i
a 1.251 c d e f g 1 h i
a 1.751 c d e f g 1 h i
a 1.3 c d e f g 2 h i
a 1.8 c d e f g 2 h i
a 1.9 c d e f g 1 h i
$ awk 'BEGIN { system("rm -f ones"); system("rm -f two"); }
($8 == 1) { print $2, $8 >> "ones" }
($8 == 2) { print $2, $8 >> "two" }' infile
$ cat ones
1.351 1
1.251 1
1.751 1
1.9 1
$ cat two
1.3 2
1.8 2
Could it be that you don't have write privledge to the current directory (try replacing "ones" with "/tmp/ones" in the script).
I was doing the script on the file that I extracted which becomes two field and the script you provided works on the original file which has many fields. Thus, the script was searching for $8 which wasn't there!!!!!
Again thank you and I really Apreciate HOW FAST YOU REPLIED
Hi Chubler_XL,
How are you? I hope you are fine......
I came today with small simple problem.....
just to remind you that in the previous posts you helped me out to first separate the results into two files ( ones, two). Also helped me to count no. of occurrence for each file..
------------------ Now-----------
What if I want to add both scripts to be in one file to avoid running two scripts each time. running one script is much easier and time consuming.
so the logic should be the following.
run the following on a file provided in the shell :
then run the count script that counts no. of occurence on each file ( "ones", "two")
and the results could be two new file ---> "ones_A", "two_B".
Note: count script should only count no.of occurrence on $1 for each file ("ones", "two").
Hello,
I came across a previous thread "awk-calculating-simple-correlation-rows" which calculated correlations across rows in awk.
Code:
awk '{
a = 0; for (i = 2; i <= NF; ++i) a += $i; a /= NF-1
b = 0; for (i = 2; i <= NF; ++i) b += ($i - a) ^ 2; b = sqrt(b)
if... (7 Replies)
Hi, I wanted to calculate cumulative frequency distribution of my data that involves several arithmetic calls. I did things in excel but its taking me forever. this is what I want to do:
var1.txt contains n observations which I have to compute for frequency which is given by 1/n and subsequently... (7 Replies)
Hi all,
I am attempting to calculate a running variance for a file containing a column of numbers. I am using the formula variance=sum((x-mean(x))^2)/(n-1), where x is the value on the current row, and mean(x) is the average of all of the values up until that row. n represents the total number... (1 Reply)
Hi All,
I have the following time stamp data in 2 columns
Date TimeStamp(also with milliseconds)
05/23/2012 08:30:11.250
05/23/2012 08:30:15.500
05/23/2012 08:31.15.500
.
.
etc
From this data I need the following output.
0.00( row1-row1 in seconds)
04.25( row2-row1 in... (5 Replies)
Hi All,
IS there any 'awk' way to manipulate following data?
Fruit Date Count
Apple 20/08/2011 5
Apple 27/08/2011 7
Apple 05/09/2011 11
Apple 12/09/2011 3
Apple 19/09/2011 25
.
.
.
.
Orange 20/08/2011 9
Orange 27/08/2011 20
Orange 27/08/2011 7
Orange 05/09/2011 15
Orange... (3 Replies)
I would like to extract a number from $0 and calculate if it can be devided by 25. Though the number can also be less then 25 or bigger than 100. How do i extract the number and how can the integer be calculated?
String:
"all_results">39</span>I am looking for the number between "all_results"> ... (5 Replies)
Hi All,
I have a txt file which has hundreds of lines and 41 fields. I have a requirement to pick up field 14 from the text file which is a date fiels in the following format.
Field 14 :
Data Type : NUMERIC DATE (YYYYMMDD)
Field Length : 8
Example of Data :20090415
Field 42 :
Data Type... (2 Replies)
Hello,
With the following small script I list the size of documents belonging to a certain user by each time selecting the bytes-field of that file ($7). Now it fills the array with every file it finds so in the end the output of some users contains up to 200.000 numbers. So how can I calculate... (7 Replies)
Hi,
I'm attempting to search, using awk, a pattern range in a file. Something like:
>awk '/first bit of text.../,/...last bit of text/' file
Is it possible to print only the last (or first) occurrence of the pattern range this way?
Thanks for any suggestions.
Al (2 Replies)
11-16-2010
