Search Results

If you wanted to combine all of your input files (with names ending in ".1" as in the 1st message in this thread) into a single output file (keeping the heading only from the 1st file), you could...

$ awk '{s = FNR==1 ? "\"""name""\"" : "\""FILENAME"\"" ; print s,$0}' OFS=',' infile >outfile

for multiple try

$ awk 'FNR==1{if(f)close(f);f="Newfile_"FILENAME}{s = FNR==1 ? "\"""name""\"" :...

This seems a little bit simpler to me:
awk '
{ while(length($2) >= 5) {
print $1, substr($2, 1, 5)
$2 = substr($2, 6)
}
}' input_filewhich produces the output:
DOG abcde
DOG fghij
CAT...

By definition, if there are an odd number of elements in a list, the median is the middle element in the (sorted) list. (So for dog, with the values in the 3rd field being 0, 3, and 4; 3 is the...

You could try something like:
#!/bin/ksh
IAm=${0##*/} # Save basename of the current script.
tempf="$IAm.$$" # Set temp filename to be used by sort.

awk -v debug="$debug" -v tempf="$tempf" '
#...

Yet one more:
awk '
/^%/{
i=$1
getline s
A[i]=(i in A)?substr(s, length(s)-8) substr(A[i],1,9):s
}
END{
for (i in A) {
print i
print A[i]
}
}
'...

Another one

awk '
$1~/^%/ {
key=$1
next
}
{
if (key in s1) {
s2[key]=substr($0,length($0)-8)
} else {
s1[key]=substr($0,1,9)
}
}...

An awk solution:
awk '
{
if ( $1 ~ /^%/ )
{
A[$1]++
i = $1
}
else
...

Oops, did not have a chance to test it. Made a correction to my post.

Try:
while read A B
do
mawk -v a="$A" 'NR>1{D[$1]+=gsub(a,x,$2); F[$1]++}; END{for (i in D) print i,D[i],F[i]}' file2 > $A.out
done < file1

The general solution in #8 should be useable, but it would be better to use code grouping {} instead of a new subshell () for every iteration..

for/while something
do
{
code segment
...

You want something more like this then:

while read A B
do
((i++))
awk '{if(NR == FNR) {a[$0]} else {for (x in a) {if($0 ~ x) {print $0; next}}}}' file2 file1 > $i.out
done

Is something like this what your after:

while read A B
do
( something
something else file1 ) > out_$A
done < file2

The while loop will call grep three times with a grep -v YES a grep -v NO and a grep -v GOOD and that output is concatenated.

Alternatively you could try without a while loop with:
grep -vf file2...

Try the below
awk '{if(NR == FNR) {a[$0]} else {for (x in a) {if($0 ~ x) {print $0; next}}}}' file2 file1

Does this help?
#!/bin/ksh
awk '
NR > 1 {# For all lines except line 1 (which contains headers; not data), loop
# through the 2nd field and increment the number of times the six
...

With the simple awk program:
#!/bin/ksh
awk '
NR > 1 {for(i = length($2) - 5; i >= 1; i--)
c[substr($2, i, 6)]++
}
END { for(i in c)
print c[i], i | "sort...

Try:
awk 'NR>1{D[$1]+=gsub(/dog/,x,$2); F[$1]++} END{for (i in D) print i,D[i],F[i]}' file

$ cat file
ID String
EN03 typehellobyedogcatcatdog
EN09 typehellobye
EN08 dogcatcatdog
EN09 catcattypehello
EN10 typehellobyedogcatcatdog
EN10 typehellobyedogcatcatdogdog
awk '
...

Assuming that having all of your columns output in the same size field works, this is a quick and dirty hack:



awk '
$2 > 30 && $5 == $3 {
for( i = 1; i <= NF; i++ )
...