1
METLIN / Re: METLIN Batch Search Output
I have a work around for not being able to download the results as a .CSV.
1. Highlight all of the text in the search field/metabolites. To do this quickly, highlight the top line, scroll down to the bottom result and hold shift and highlight the last line, this should grab all text in between.
2. Copy and paste all text using "Match Destination Formatting". This eliminates the images, colouring and stuff, reducing the chance Excel will freeze.
3. Click on the "A" button at the top of Column A, go to "Find and Replace", skip the first box so that it is looking for blank cells and add something unique to the "Replace with" box. For example, "AAA".
4. Manually delete rows until you have METLIN ID, Mass, delta ppm etc. as the top row of the sheet.
5. Filter the top row using column A to find rows that do not contain metabolites. For example, this row should only contain numbers between 3 and 6 digits, so you can search "daltons" and delete all rows containing that phrase. Then repeat this for other phrases "m/z", "showing", "next" etc.
6. You should end up with a table containing just the metabolites organised by increasing mass and none of the other guff. Basically, it looks like a .CSV that you can download from HMDB or somewhere similar.
Hope it helps!