Need help to extract specific data from text file using vba
Hi, I am fairly new to using vba. I have a set of data listed below I will need to extract the date which is on the file name minus the first number (E.g 220171114A only the 20171114), under the instrument response section, the IR_Avg_Offset value (the number after the semicolon).
The lay out of the worksheet will be- 1st column date, 2nd column rx1 IR_Avg_Offset value, 3rd column rx 2 IR_Avg_Offset value and 4th column rx3 IR_Avg_Offset value
I would also need to open up a browser and select the file to import the data from. Lastly the new data is it possible to use vba and set it to insert into the next available row in column 1,2,3 and 4?
* the data that needs to be extracted are yellow in colour
Sorry for so many request I would really need help on this thanks.
/Created On: 11/22/2017 10:16:32 AM
/Import File Name: 220171114A.G63
/Export File Name: 220171114A_pro.xyz
Action: Invert_Data
************************************************** ***
Input_Array: EM_Raw
Output_Array: EM_Raw
Applied_To: Line Rx2
************************************************** ***
Action: Multi-Point Leveling
************************************************** ***
Input_Array: EM_Raw
Output_Array: EM_MPLev
Total_Points: 3
Applied_To: Line Rx1
Late_Time: No
Late_Time_Channel: -1
ID Record Position Width
1 138 138 10
2 1492 1492 10
3 6474 6474 10
************************************************** ***
QC Check: Instrument Response Statistics
************************************************** ***
Applied_To: Line Rx1
IR_Channel: EM_NLFilt[3]
Range_Selection: Automatic
IR_Avg_Offset: 389.9
IR_Percent_Error: 4.0
IR_DQO: 375
IR_Pass_Criteria: 10
DQO_Results: PASS
************************************************** ***
QC Check: Instrument Response Statistics
************************************************** ***
Applied_To: Line Rx2
IR_Channel: EM_NLFilt[3]
Range_Selection: Automatic
IR_Avg_Offset: 367.2
IR_Percent_Error: 2.1
IR_DQO: 375
IR_Pass_Criteria: 10
DQO_Results: PASS
************************************************** ***
QC Check: Instrument Response Statistics
************************************************** ***
Applied_To: Line Rx3
IR_Channel: EM_NLFilt[3]
Range_Selection: Automatic
IR_Avg_Offset: 374.0
IR_Percent_Error: 0.3
IR_DQO: 375
IR_Pass_Criteria: 10
DQO_Results: PASS
|