Search Results

Can you explain the code ( the $4??)
My file 1 is like:
MSTRG.1.1 233 0 0 0
MSTRG.5.1 2151 300 0.7186
MSTRG.13.1 1705 261 0.4076
MSTRG.49.1 ...

Apologies, this is my first post. I thought it would be easier to explain with an ammended file but I've learnt this confuses things. My file 2 looks like this.

1 StringTie exon ...

Thanks vgersh99 but I can't quite get this to work. Could you explain the code?

Thanks RudiC. It's not quite working and I think it might know why. I've realised column 7 in file two is actually wrapped in ""; So I'm guessing the strings won't exactly match? eg

file2.txt...

Hi,
I have been trying to find help with my issue and I'm thinking awk may be able to do it.
I have two files eg
file1.txt
STRING1 230 400 0.36
STRING2 400 230 -0.13
STRING3 ...