Log In
Register
Home
Active Member
September 20, 2019
Offline
have one folder with a lot of "DAT file"-s
I need to pull in one worksheet values from cells A3 and A4 from all Dat file-s.
October 5, 2010
Offline
Hi Ivica,
We'll need to see some of these DAT files to understand how the data inside them is structured. Can you please supply some.
Do you want all data from the DAT files imported or just some parts?
Regards
Phil
Active Member
September 20, 2019
Offline
It is "dat." files. I need just values from cell A3 and A4.
Column A
| ----- PRODUCTION START ----- |
| Putting: 31.05.2019 09:32:08 |
| Lot number: 12345678 |
| Material type: B59288R190B10 |
October 5, 2010
Offline
I am not familiar with your dat files structure which is why I need to see examples.
Even with the data you supplied above it's not clear what the next line is. Is it the beginning of another set of related data? Is it a blank line? Is it more data relating to the 3 preceding bits of data?
There's no point writing code that will break the first time you use it because it is not able to handle the structure of the file.
Regards
Phil
1 Guest(s)
