|
|
#1
03-14-2018, 06:00 AM
|
|||
|
|||
importing and xonditioning data from a text file
Hello everyone.
I searched over the forum for a solution but couldn’t find one. I have a text file that is updated daily by adding more rows. This is how the text file looks,except there are hundreds of rows:  When importing this data into EXCEL I only need certain values to appear from each row(CD,UNIT,Oper,VAL,DateTime)so I manually delete most of the columns to get just the data I need,like this:  What is the best way to automate this process? Will appreciate your help. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need help to extract specific data from text file using vba | victor92 | Excel Programming | 0 | 12-01-2017 12:53 AM |
 Importing Data from seperate closed excel file
|
KingoftheKassel | Excel Programming | 1 | 06-10-2016 08:34 AM |
| An error occurred while importing this file <image file> | melvinjn | Drawing and Graphics | 1 | 01-19-2015 01:32 AM |
|
How to convert a text file to an Excel file with the data format automatically?
|
mradmin | Excel | 6 | 10-16-2013 10:34 AM |
|
extracting data from Table to text file
|
Anirudh_Dsp | Word Tables | 1 | 05-23-2010 07:48 AM |
Windows 8 
Office 2010 64bit
Threaded Mode