#1
|
|||
|
|||
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 |
Tags |
specific data, text to excel, vba |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Search for specific data in a text string | teligence | Excel | 1 | 05-20-2017 11:51 AM |
extract specific pivot table data to a new sheet | theexpat | Excel Programming | 0 | 02-18-2016 10:08 AM |
Extract data based on pattern with respect to specific column | PRA007 | Excel Programming | 14 | 12-04-2015 04:32 AM |
Extract Data From Text file based on Pattern | PRA007 | Word VBA | 13 | 11-01-2015 11:20 PM |
Extract Line of Text w/ specific characters up to the paragraph character, send to Excel | dmarie123 | Word VBA | 10 | 07-20-2015 12:16 AM |