Dear Friends,
I have a specific problem where the .txt file is as provided in the input file.txt and would like to have an VB excel script which should provide the output as provided in the desired output.
I have to perform this for more than 1000 .txt files. Any kind of help is appreciated.
Input format in .txt file:
>gi|1234|ref|
Query = 1 - 65, Target = 1677 - 1733
Score = 8.38, E = 0.6529, P = 0.0001513, GC = 46
fd sdfsdfsdfsdf
fsdfdsfdfdfdfdfdf
dfdfdfdfedfsdfsdfdsf
dfdfdfsdfsdfsdfsdfdsf
sdfdsfdfdfdfdsfdfdfdfd
>gi|54367|ref|
fd sdfsdfsdfsdf
fsdfdsfdfdfdfdfdf
dfdfdfdfedfsdfsdfdsf
dfdfdfsdfsdfsdfsdfdsf
sdfdsfdfdfdfdsfdfdfdfd
Query = 1 - 65, Target = 6780 - 6812
Score = 8.13, E = 0.7692, P = 0.0001782, GC = 36
................................EOF................................
where as the output should be like the following table format:
<TBODY>
</TBODY>
Looking forward for any kind of help in this regard.
Best regards,
Amit
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
I have a specific problem where the .txt file is as provided in the input file.txt and would like to have an VB excel script which should provide the output as provided in the desired output.
I have to perform this for more than 1000 .txt files. Any kind of help is appreciated.
Input format in .txt file:
>gi|1234|ref|
Query = 1 - 65, Target = 1677 - 1733
Score = 8.38, E = 0.6529, P = 0.0001513, GC = 46
fd sdfsdfsdfsdf
fsdfdsfdfdfdfdfdf
dfdfdfdfedfsdfsdfdsf
dfdfdfsdfsdfsdfsdfdsf
sdfdsfdfdfdfdsfdfdfdfd
>gi|54367|ref|
fd sdfsdfsdfsdf
fsdfdsfdfdfdfdfdf
dfdfdfdfedfsdfsdfdsf
dfdfdfsdfsdfsdfsdfdsf
sdfdsfdfdfdfdsfdfdfdfd
Query = 1 - 65, Target = 6780 - 6812
Score = 8.13, E = 0.7692, P = 0.0001782, GC = 36
................................EOF................................
where as the output should be like the following table format:
Serial | Query start | Query End | Target start | Target End | Score | E | P | GC | |||||||||
<TBODY> </TBODY><COLGROUP><COL><COL><COL><COL span=6></COLGROUP> | 1 | 65 | 1677 | 1733 | 8.38 | 0.6529 | 0.000151 | 46 | |||||||||
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> | 1 | 65 | 6780 | 6812 | 8.13 | 0.7692 | 0.000178 | 36 |
<TBODY>
</TBODY>
Looking forward for any kind of help in this regard.
Best regards,
Amit
</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>