Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import selected data
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import selected data
Hi J,
What you are asking for is difficult to solve, at least with the experience I have had with importing data reports in text format. Generally there must be an exceptional amount of consistancy in the report you are importing, which means cutting and pasting the data here, will not necessarily yield that consistant result. Cutting and pasting your data into Word does not necessarily give representative results either, but maybe fairly close. Anyway looking at it in Word, it appears that importing it would be fairly difficult and the actual data file would have to be experimented with and even then results may not allow for direct import. It does appear that there is consistancy in the "data" area, but maybe not in the "header" area, which means the date you are trying to pull out could be lost, but maybe that could be supplied some other way. To attemp what you have, someone needs to experiment with your actual files, not what has been rendered here. Thanks, "J" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |