Search Results

awk -f ab.awk FDA_Approved_drugs_names_sectioned.txt Drug-Gene_match_dgidb.txt where ab.awk is:

BEGIN {
FS=OFS="\t"
}
FNR==NR {a[$1]=$0;next}
{
for (i in a) {
one=$1
...

If you can afford to keep the data in memory, the following approach should me more efficient:

awk '
{
for (i=1; i<=NF; i++)
a[NR,i] = $i
}

END {
tmp_file = "tmp"
sort_cmd = "sort...

Try this:
#!/bin/ksh
IAm=${0##*/}
base="${IAm}_$$_"
trap 'rm -f "$base"*' EXIT
file=${1:-file}
nf=1
while [ 1 ]
do tmpname=$(printf "%s%03d" "$base" $nf)
cut -f $nf "$file" > "$tmpname"...

I have corrected the code.
Its kind of difficult to code and post via mobile/tablet ;)

awk 'NR==FNR{A[$4]=$0; next} $6 in A{ print A[$6]"\t"$0 }' file1 file2

awk 'NR==FNR{A[$1];next}!($2 in A)' file1 file2

Read input file twice:
awk -F'\t' '
NR == FNR {
v = $1 FS $5
if ( ! ( v in A ) )
C[$5]++
A[v]
...

cat list.txt | while read pattern; do find sourcedir -name "*$pattern*" -exec mv '{}' destdir/ \;;doneEmanuele

Try:xargs -I% find /source -name "*%*" -exec mv {} /destination \; < list.txt

The ~/RE/ searches for "chr6" being a substring:
awk '$1~/chr6/ && $2~/chr6/' file
The exact string match:
awk '$1=="chr6" && "$2=="chr6"' file

Try this if all columns needs to be compared:
awk 'NR==FNR{A[$1];next}$1 in A || $2 in A || $3 in A' file1 file2
If just column 2 needs to be compared:
awk 'NR==FNR{A[$1];next}$2 in A' file1 file2

awk '{n=gsub(/0\/1|1\/1/,"&");print $0,n}' file

To display the count in the end of each record:
awk '{n=gsub("0/1","&");print $0,n}' file
To display total count:
awk '{n=gsub("0/1","&");c+=n}END{print c}' file

OK. I can't really tell from your example, but it looks like you intend to have tabs as field separators. I will assume that the tabs were changed to spaces as part of a copy and paste process. ...

When I invoke the script I provided in message #4 in this thread as follows:
cp mtDNA_GATK_reference_letters.txt in
tester 2 A C > out
then the only difference between files...

try this.....

Just pass parameters..
NUM=position of the string from first line.
Rpl=Check if this letter presents
subs=Replace with this letter

awk -F "" -v NUM="2" -v Rpl="A" -v subs="C"...

Here is a much longer alternative way to do this:
#!/bin/ksh
# Usage: tester [count [from [to]]]
# Change the "count"th occurrence of the character specified by "from"
# to the...

awk -v p=150 -v l="C" '{for (i=1; i<=length($0); i++) {++c; o=$0; if (c==p) o=substr($0,1,i-1) l substr($0,i+1);};print o;}' infile

try this...

awk -F "" '{if((max+NF)>150){for(i=1;i<=NF;i++){if((max+i) == 150 && $i ~ /T/){$i = "C"}}}else{max+=NF}}1' file