Read .txt file

Hello all. I initially posted a problem a few days ago, but I was advised include an actual sample file instead of a replica. Anyways, the problem is the my instrument, MS.txt, gives me my data in a format that I have to meticulously format in excel. Ideally, I'd like to extract the necessary data file MS.txt and insert it into a new worksheet, properly formatted. I included a file, IdealFile.xls, to give an example of what I'd like to have as a result.


Key items for extraction:

1. The "SampleID" is assigned to each data set. It appears near the top of each data set.
2. "Analyte" is denoted by 1 or 2 letter chemical symbols.
3. The "Mass" of analyte is to the right of the "Analyte" symbol.
4. "Conc. Mean" is to the right of the "Mass".

All help is greatly appreciated. Even if you can only partially solve my problem, I would be thankful. Thanks in advance.

Hi

See how this goes.

Make sure your output file has sheets named Sheet2 and Sheet3.

Please Login or Register  to view this content.

rylo

Hello Te$la,

This macro will read the text fle MS.txt and place it on the Active Worksheet starting at row 3 in columns "B" through "E". Change the file path for FileToOpen highlighted in blue.

Please Login or Register  to view this content.

To Install the Macro:
1. Copy the Macro code above using CTRL+C
2. Open Excel and Right Click on any Sheet Tab
3. Click on View Code in the pop up menu
4. Use ALT+I to activate the VBE Insert Menu
5. Press the letter m to insert a Standard Module
6. Paste the macro code using CTRL+V
7. Save the macro using CTRL+S
8. Close the VBE and return to excel using ALT+Q

Sincerely,
Leith Ross

Thanks a lot. I'll try to get this implemented at work today.