Exactly what output you are trying to produce from your sample intermediate output (with the percentages you said you want, but did not describe).
but you decided not to show us what output you want for percentages. The code that you say produces the percentages you want is not at all helpful since the code depends on three variables (cc, the array c, and the variable r) none of which have defined values that you have shown us. If this is awk code and these variables haven't been otherwise defined, this code goes through the for loop zero times and prints an empty line. I assume that you do not want an empty line, but I still have no idea what output you do want (other than that your percentages are to be calculated to two decimal places and that you want to include the line containing the headings in your input file in your calculations).
As I said before, there is not such thing as an empty space. From your latest sample input, we see that your use of the term empty space should be treated as a synonym for single space character, but if that is the case, you still need to explain why a single space in field two is not a subset of field 1 in the line:
where the 8th character in field 1 is a single space character and field 2 is a single space character.
And, you still have not defined what string is similar means in your statement:
Quote:
1. if col1 string is similar col2 string or even the substring then it shall be TRUE POSITIVE
Please show us the EXACT output you are hoping to get from your script (including the percentages).
Please explain how we determine whether or not two strings are similar.
Please explain why a field that is a single space character is not a subset of a field containing a space character>.
And, please explain why two non-empty strings (each containing a single space) that are identical are classified under your rule #4 instead of being classified under your rule #1.
how would you calculate percentage by per line? Given a column of 16 lines, grab each line and divide it by the sum of the entire column and multiply by 100?
thanks ... (8 Replies)
Hi all,
Is there a way to convert full data matrix to linearised left data matrix?
e.g full data matrix
Bh1 Bh2 Bh3 Bh4 Bh5 Bh6 Bh7
Bh1 0 0.241058 0.236129 0.244397 0.237479 0.240767 0.245245
Bh2 0.241058 0 0.240594 0.241931 0.241975 ... (8 Replies)
Hi everyone
I am very new at awk but think that that might be the best strategy for this. I have a matrix very similar to a correlation matrix and in practical terms I need to convert it into a list containing the values from the matrix (one value per line) with the first field of the line (row... (5 Replies)
i am trying to get percentage : but not able to do it:
i tried :
x=1
y=2
z=`expr $x/$y*100`
it is not giving me result
can u pls help on this (4 Replies)
Dear all,
I have data like below and i need to add coloumn before the COUNT field to see the Percentage out of all COUNT field value for respective raw.
=============================================
COUNT CODE sConnType tConnType... (6 Replies)
Hi,
I am looking for generic commands / scripts that could run across platforms especially on HP Itanium boxes to give me % of free OS parameters
For eg:
Free Total Memory RAM : 20 %
Free Total Swap Memory: 35%
Free Total CPU utilisation: 44%
Free Disk Space: /appl = 55%... (5 Replies)
This matrix represents correlation values.
Is it possible to calculate the percentage of columns (a1, a2, a3) that have a value >= |0.5| and report the percentage that has positive correlation >0.5 and negative correlation <-0.5 separately. thanx in advance!
input
name a1 a2 a3... (5 Replies)
Hi,
I have a text file in below format.
I trying to find a solution for finding percentage used for each of the NAMEs.
Directory ALLOCATED USED
NAME1 93MB 93KB
NAME2 25G 62K
NAME3 14G 873M
NAME4 25G 62K
NAME5 20G... (10 Replies)