LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
j j is offline
external usenet poster
 
Posts: 128
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error Alert for Invalid Data doesn't work for data selected in col genegal Excel Worksheet Functions 0 January 25th 10 04:17 AM
import XML data...Is there a size limit on the import? MatthewG Excel Discussion (Misc queries) 0 February 10th 09 05:57 PM
How to Start Excel in Text Import Wizard for data import rlelvis Setting up and Configuration of Excel 0 July 10th 08 08:40 PM
Excel should be able to import selected data from MS Word family1935 Excel Discussion (Misc queries) 0 February 13th 06 08:36 PM
Import selected lines from an Ascii file drbobsled Excel Programming 1 June 23rd 04 12:19 AM


All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"