Remove all comments, change elsefor for else for & p90 = tot *.8
Code:
$ awk '
FNR == 1 && cnt {
p90 = tot * .8
for(i in cc) {
if(cc[i] > p90) {
off = index(i, SUBSEP)
rep[substr(i, 1, off - 1)] = substr(i, off + 1)
}
delete cc[i]
}
}
FNR == NR {
if($2 == "Freq") {
cnt = $3
tot += cnt
} else for(i = length($0); i > 0; i--) {
if((c = substr($0, i, 1)) == "-") continue
cc[i, c] += cnt
}
next
}
NF == 1 {
for(i = length($0); i > 0; i--)
if((substr($0, i, 1) == "-") && (i in rep))
$0 = (i > 1 ? substr($0, 1, i - 1) : "") rep[i] \
substr($0, i + 1)
}
1' Input.txt Input.txt
I'm glad you got something that works for you.
If you look back at the code I supplied in post #6 in this thread, you might note that there is no elsefor anywhere in it. And, I would NOT have removed the tabs since the structure of the code is hidden without them.
For my own sanity, if I would have been updating the code to your new requirements, I would have changed p90 = tot * .9 to p80 = tot * .8 and globally changed other references to what used to be p90 to instead be p80. Or, if it is likely to change again, rename the variable something like threshold or LowLimit or limit.
I left in the comments so you could see the calculations that were accumulated during the 1st pass through the data and see the replacements that could be performed by the 2nd pass. If you didn't understand how the code worked, uncommenting those lines would have given you a peek under the covers at what is going on. And, if you run into some anomalous data in the future, it might be nice to have that debugging code as a backup to quickly get a look at what the script gathered from your data.
hi.
I have a Fixed Length text file as input where the character positions 4-5(two character positions starting from 4th position) indicates the LOB indicator. The file structure is something like below:
10126Apple DrinkOmaha
10231Milkshake New Jersey
103 Billabong Illinois
... (6 Replies)
Hello,
For example:
12........6789101112..............20212223242526..................50 ( Positions)
LName FName DOB (Lastname starts from 1 to 6 , FName from 8 to 15 and date of birth from 21 to29)
CURTIS KENNETH ... (5 Replies)
Hi
My file has a series of rows up to 160 characters in length.
There are 7 columns for each row.
In each row, column 1 starts at position 4
column 2 starts at position 12
column 3 starts at position 43
column 4 starts at position 82
column 5 starts at... (7 Replies)
I have a list of about 200,000 lines in a text file that look like this:
1 1 120
1 80 200
1 150 270
5 50 170
5 100 220
5 300 420
The first column is an identifier, the next 2 columns are a range (always 120 value range)
I'm trying fill in the values of those ranges, and remove... (4 Replies)
I am attempting to replace positions 44-46 with YYY if positions 48-50 = XXX.
awk -F "" '{if (substr($0,48,3)=="XXX") $44="YYY"}1' OFS="" $filename > $tempfile
But this is not working, 44-46 is still spaces in my tempfile instead of YYY. Any suggestions would be greatly appreciated. (9 Replies)
I have files with hundreds of sequences with missing characters represented by a dash ("-"), something like this
I need to go sequence by sequence and if a dash is found, it should be replaced with the most common character in that particular position. Thus, in my example the dash in the second... (6 Replies)
This is what I would like to accomplish, I have an input file (file A) that consist of thousands of sequence elements with the same number of characters (length), each headed by a free text header starting with the chevron ‘>' character followed by the ID (all different IDs with different lenghts)... (9 Replies)
