Hi, I have a text that include some number in latest line and I would like to extract this numbers to a separate file. Can anyone help me in this regard. A sample file of mu results is attached.
Regards
What will you do with the numbers? I can right-click on it and open it into Excel (please see attached excel file)
Dear jack
I need only the numbers of last line for example in following set only "7.457" "0452" and "2.711" are needed. in a real study the number of the data sets are more than 1000 so copy past is very tedious.
No.2 >WP_013401468.1 MULTISPECIES: nitrite reductase [Bacillaceae]
6.101 0.452 4.519 4.067 3.841 7.231 3.841 3.615 6.10 3.841 3.389 4.745 4.293 2.486 1.582 2.711 5.875 7.457 0.452 2.711
Just open it in Excel, and delete the data you don't need. In the example you gave, delete the rows of data you don't need. The data you want is in columns H, I, and J, so delete the columns A through G. you'll be left with the three numbers that you want.
Alternatively, learn Visual Basic for Applications (VBA), and write a program to remove the data you don't need, or copy the desired data to a new sheet, or read the original text file, parse out parse the data you do want, and save it in whatever format works for you.
- Badges
- Science topic
- Similar topics
- Phytochemistry
- Extracts