10-02-2010
thanks for the reply treesloth.
As I am new, I was searching for awk, grep and sed commands functionality, but not able to get how the calculation can be done.
please help.
I am trying to calculate the values in last column, if EUR appears in column 2 of any line of file 1 and in the first column of any line of 2, perform the given calculation on those lines, likewise for other currencies also and if there are no matches, those records must be as is in output file.
Thanks again treesloth
I am trying to calculate the numbers
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi
I know its a dumb question but can any one please explain me the difference of executing a shell script in the following 2 ways.
. script.sh
sh script.sh
I have a problem if I execute the following code as sh script.sh
DB_CNT_ALW=0.20
SCT_VAR=0.05
if ; then
echo "== Difference... (3 Replies)
Discussion started by: shash
3 Replies
2. Shell Programming and Scripting
Hi,
There is a file having a list of running PIDs and another file having
a list of registered PIDs. How can we check if each value of running
PIDs are less or more than the registered PIDs i.e. comparing the
value of each PID in both the files.
Request you to pls give your inputs. ... (2 Replies)
Discussion started by: marconi
2 Replies
3. Shell Programming and Scripting
Hi all,
I have got a problem while comparing 2 text files and the result should contains the unique values(Non repeatable).
For eg:
file1.txt
1
2
3
4
file2.txt
2
3
So after comaping the above 2 files I should get only 1 and 4 as the output. Pls help me out. (7 Replies)
Discussion started by: smarty86
7 Replies
4. Shell Programming and Scripting
i have two file and i am comparing both..
in cmp1 ,the content is :
the nu of file is : <some integer value>
in cmp2 ,the content is :
the nu of file is :
so want a script which will take value (2) when cmp1 is compared with cmp2..
i mean cmp cmp1 cmp2 the the output will be
he nu of... (1 Reply)
Discussion started by: Aditya.Gurgaon
1 Replies
5. UNIX for Dummies Questions & Answers
I have two text files where the first three columns are exactly the same. I want to compare the fourth column of the text files and if the values are different, print that row into a new output file. How do I go about doing that?
File 1:
100 rs3794811 0.01 0.3434
100 rs8066551 0.01... (8 Replies)
Discussion started by: evelibertine
8 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have two text files with matching first columns. Some of the values in the second column do not match. I want to write a script to print out the rows (only the first column) where the values in the second column do not match.
Example:
Input 1
A 1
B 2
C 3
D 4
Input 2
A 2
B 2... (6 Replies)
Discussion started by: evelibertine
6 Replies
7. Shell Programming and Scripting
Hello,
I am using Awk in UBUNTU 12.04.
I have a file as follows, the first column represents the name of populations, in my real file, I have 47 populations and 2172 lines in total with about 47000 fields.
ABO_1 1 2
ABO_1 1 2
ABO_2 1 1
GPO_1 1 1
GPO_1 2 2
GPO_2 1 0
GPO_2 2 0
I want... (3 Replies)
Discussion started by: Homa
3 Replies
8. Shell Programming and Scripting
Hi
Am trying to compare the values of two files..
One is a big file that has many values and the other is a small file..
The big file has all values present in small file..
# cat SmallFile
4456602 22347881
7471282 15859891
8257690 21954701
7078068 18219229
2883826 6094959
100000
... (3 Replies)
Discussion started by: Priya Amaresh
3 Replies
9. Shell Programming and Scripting
Hello everyone, I have a dataset that looks like:
1 2
3 4
5 6
I was wondering if was possible to divide values within rows:
1/2
3/4
5/6
I don't think using awk -F"\t" '{ print $1/$2 }' would work here, or would it?
Thanks in advance! (2 Replies)
Discussion started by: Rabu
2 Replies
10. Shell Programming and Scripting
First I'd like to apologize if I opened a thread which is already open somewhere.
I did a bit of searching but could quite find what I was looking for, so I will try to explaing what I need.
I'm writing a script on our server, got to a point where I have two files with results. Example:
File1... (6 Replies)
Discussion started by: mitabrev83
6 Replies
LEARN ABOUT MINIX
tabfunc
TABFUNC(1) General Commands Manual TABFUNC(1)
NAME
tabfunc - convert table to functions for rcalc, etc.
SYNOPSIS
tabfunc [ -i ] func1 [func2 ..]
DESCRIPTION
Tabfunc reads a table of numbers from the standard input and converts it to an expression suitable for icalc(1), rcalc(1) and their
cousins. The input must consist of a M x N matrix of real numbers, with exactly one row per line. The number of columns must always be
the same in each line, separated by whitespace and/or commas, with no missing values. The first column is always the independent variable,
whose value indexes all of the other elements. This value does not need to be evenly spaced, but it must be either monotonically increas-
ing or monotonically decreasing. (I.e. it cannot go up and then down, or down and then up.) Maximum input line width is 4096 characters
and the maximum number of data rows is 1024. Input lines not beginning with a numerical value will be silently ignored.
The command-line arguments given to tabfunc are the names to be assigned to each column. Tabfunc then produces a single function for each
column given. If there are some columns which should be skipped, the dummy name "0" may be given instead of a valid identifier. (It is
not necessary to specify a dummy name for extra columns at the end of the matrix.)
The -i option causes tabfunc to produce a description that will interpolate values in between those given for the independent variable on
the input.
EXAMPLE
To convert a small data table and feed it to rcalc for some calculation:
rcalc -e `tabfunc f1 f2 < table.dat` -f com.cal
AUTHOR
Greg Ward
SEE ALSO
cnt(1), icalc(1), neaten(1), rcalc(1), rlam(1), total(1)
RADIANCE
10/8/97 TABFUNC(1)