Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have .txt files with data in the following format:
Title : Run File : c:\star\qi zu\data files\2-2-05\sv=10000\2003.36==2-3-05==2;43;36 pm.run Method File : C:\Star\Qi Zu\method\SRM.mth Sample ID : inject #75 Injection Date: 2/3/05 2:43 PM Calculation Date: 2/3/05 2:45 PM Operator : Qi Zu Detector Type: 2003 (16 Volts) Workstation: Bus Address : 36 Instrument : Trey Sample Rate : 50.00 Hz Channel : A = MS 10m Ar Run Time : 1.667 min ** Star Chromatography Workstation Version 5.52 ** 02178-6230-082-0240 ** Run Mode : Analysis Peak Measurement: Peak Area Calculation Type: External Standard Ret. Time Width Peak Peak Result Time Offset Area Sep. 1/2 Status No. Name (%) (min) (min) (counts) Code (sec) Codes ---- ------------ ---------- ------- ------- ---------- ---- ----- ------ 1 Hydrogen 73.3316 0.492 0.027 12365535 BB 2.1 2 Nitrogen no result 0.650 -0.071 1904 VP 4.7 C* 3 Methane 10.4979 0.951 -0.049 808345 BV 4.6 ---- ------------ ========== ------- ======= ========== ---- ----- ------ What I need to do is grab the Injecton Date, Peak Names and Area (Counts) and put them in an Excel Spreadsheet so that the data looks like: Injection Date Hydrogen Nitrogen Methane 2/3/05 2:43 PM 12365535 1904 808345 I would need to get this data from all files in a folder. Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Alert for Invalid Data doesn't work for data selected in col | Excel Worksheet Functions | |||
import XML data...Is there a size limit on the import? | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Excel should be able to import selected data from MS Word | Excel Discussion (Misc queries) | |||
Import selected lines from an Ascii file | Excel Programming |