Search Results

Try:awk '{for (i=2;i<=NF;i+=3) printf ($i+$(i+1))/2" ";printf "\n"}' file

try:
awk '$2 == "NA" {$2=$1":"$4} 1' OFS="\t" infile

Just enclose the file name variable in double quotes as below:


for i in {1..100}; do cut -f1 "data_$i.txt" > "output$i.txt"

If I understand what you are trying to do, try this:
for i in {1..10}; do awk '{$3=i; print}' i=$i data$i.txt > output$i.txt; done

Please note that variable expansion happens only inside double quotes not single quotes.

awk ' { gsub(/.*\(|\).*/,x) } 1' file

$ awk '!A[$2]++' file
1 rs4040617 0.08356
1 rs2977612 0.07948
1 rs2980300 0.08356


This looks much like your previous thread!

And, please start using code tags.

awk '$1!=$2{$4=$4*2}$1==$2{$4=$4*2+1}1' file

awk 'f==$1&&s!=$2{print c;print}{f=$1;s=$2;c=$0}' file

If I understood correctly, you could try this:

awk '$2>($6-1000000) || $2<($7+1000000)'

While thinking twice, I came to the conclusion that the above should better read

awk '$2>($6-1000000)...

I'm not sure any tool will handle lines at least 4 million chars long (one char cols assumed). Where do these loooong lines come from? A database? Can't they be created in a different way from the...

Does the first column have a fixed width?

Some more information on the file would be nice, too. Do the columns have a maximum width? Or better yet, a fixed width?

The correct procedure involves candles, the sacrifice of rum, tobacco and a living chicken, then invoking the following ritual chant ....

Seriously: if we are supposed to help you with a problem...

Transpose into what? Vice versa?

Standard tool, then.

Even ordinary awk can handle this if you fiddle with the record and field separators so it reads one column at a time, what to do with it is the question. Millions of columns...

:%s/<space>/<tab>/

Try:
awk '{if(NF==1)$0=p FS $0; else p=$1 FS $2}1' file

awk '{s=$1; for(i=$2; i<=$NF; i++) s=s OFS i; print s}' file

awk '{ printf "%d ",$1; j=$2; while(j<=$NF) { if(j==$NF) { printf "%d\n",j; j++; } else { printf "%d ",j; j++; } } }' filename

Try:
awk '{$3=0 OFS $3}1' file

sort -k4,4gr input.txt

Assuming that your lines_file contains each line number on a separate line (and that you don't want to consider duplicate line numbers, if they exist):
awk 'FNR==NR{a[$1];next}FNR in a' lines_file...

awk '{$2=$2<=3?"LOW":($2<=6)?"HIGH":"UNKNOWN")}1' file

we can do with elseif..
awk -F'|' '{if($2=="1") {print $1"|"$5} else if($2=="2") { print $1"|"$5"|"$7}}' test.txt