Zeros in columns 9-14 are result of subtraction... I don't know if it is what you wanted, but my code is taking first number in each column that is other than zero, and then subtracts its value from all the other numbers in that column. If this is not how it should work, then please be more clear on your requirements and post desired output for that sample data.
Sorry for not being clear.
So here is an example:
Input file:
Needed output:
So here (starting with column 3) when a column is all = 1 it all becomes =0 , the other columns are multiplied by the first column.
Hi all,
i was doing a small program where if i was to be given the first 3 letters of any month i.e. in the form of Jan or Apr then it would return the column number where it finds a match. To do this i created a 12 element array of months with first 3 letters and if i echo'ed the contents of... (2 Replies)
I have a data file that is arranged like this:
Marketing Ranjit Singh Eagles Dean Johnson FULL
Marketing Ken Whillans Eagles Karen Thompson FULL
Sales Peter RobertsonGolden TigersRich Gardener PART
President Sandeep Jain Wimps Ken Whillans CONT... (7 Replies)
Does anyone know how to include as a script maybe an "echo" warning that explains that if a user uses the second number "zero" when dividing, that the result will BE "zero."
I need, example: 5/0 (second number) = 0, in script form.
current script:
echo "Enter a number"
read num1
echo... (4 Replies)
Hi Guys,
I have a question on how i can get the column number in a file and used it in awk.
i have a file which it has these records inside it.
... (7 Replies)
Input file :
5 20
500 2
20 41
41 0
23 1
Desired output :
5
2
20
0
1
By comparing column 1 and 2 in each line, I hope can print out the column with smallest number.
I did try the following code, but it don't look good :( (2 Replies)
I currently have two programs written in C named "remove" and "calculate.
When I call ./remove it removes some data from stdin.
When I call ./calculate which takes in an argument and also data from stdin and calculates and returns a value.
Currently writing a script that calls both of these... (1 Reply)
please write a shell script
Table
--------------------------
1 2 3 a b c
3 4 5 c d e
7 8 9 f g h
Output should be like this
---------------
1 2 3
3 4 5
7 8 9
a b c
c d e
f g h (1 Reply)
Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records
Table
---------
Col1 col2 col3 col4 ....................col20
1 2 3 4 .................... 20
a b c d .................... v
... (11 Replies)
Hi!
I have a file as below:
0.000145 5.82056e-08
0.000146 6.82088e-08
0.000150 7.42115e-08
0.000156 8.52142e-08
0.000176 8.82169e-08
0.000178 9.82197e-08
I'd like to divide the values of the second column by its last entry (here 9.82197e-08).
I would be thankful if someone could... (6 Replies)