|
03-14-2018, 06:00 AM
|
|
Novice
|
|
Join Date: Mar 2018
Posts: 2
|
|
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.
|