Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-01-2017, 12:53 AM
victor92 victor92 is offline Windows 10 Office 2016
Novice
 
Join Date: Dec 2017
Posts: 1
victor92 is on a distinguished road
Default 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
Reply With Quote
Reply

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


All times are GMT -7. The time now is 12:04 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft