In the attached .txt file, I am trying to match $5 with $1 and copy $4 to $7.
That file was created using:
awk 'BEGIN {OFS="\t"} {sub("chr","",$1)} {print $5,$2,$3,$1,$4,$7} {print $6,$3,$2,$1}' matrix_pxlence.txt > output.txt
but I can not seem to add this last bit to the command. Thank you :).
Example output:
$5 = DTE3504500000001 and in $1 Row 1 and 2 contains that text (before ref or antiref), so $4 which is 1 is copied to $7 with the header combined.
DTE3504500000001ref 34529 35031 1 DTE3504500000001 SeqRxn4 1
DTE3504500000001antiref 35031 34529 1
Thank you :).