Importing multiple text files and getting certain figures.

[X82]

Hi guys.

I will try to explain this situation best I can.
I have about 500 .txt files. Here is a link to example files, 4 i
total.

https://docs.google.com/folder/d/0B0U_dFIXO1labHBPaXZKMWlSUGs/edit

The red parts of the files are the figure I need importing into excel
So there is about 500 txt files with 4 different variations of th
file.

I also would like to import the filename of the txt file in a column. S
column A would read, AMAB3.txt and column B would be the figure pulle
from the txt file, say 1.9 or 5.6 etc. In a long list.

I'm sorry if I've explained this terribly and I will try to clear up an
issues. All help on this matter is appreciated

 

[Don Guillett]

Hi guys.



I will try to explain this situation best I can.

I have about 500 .txt files. Here is a link to example files, 4 in

total.



https://docs.google.com/folder/d/0B0U_dFIXO1labHBPaXZKMWlSUGs/edit



The red parts of the files are the figure I need importing into excel.

So there is about 500 txt files with 4 different variations of the

file.



I also would like to import the filename of the txt file in a column. So

column A would read, AMAB3.txt and column B would be the figure pulled

from the txt file, say 1.9 or 5.6 etc. In a long list.



I'm sorry if I've explained this terribly and I will try to clear up any

issues. All help on this matter is appreciated.

You could change from .rtf to .txt and then open in excel. Then you would need the logic of why 4.5 is the value you want from which file and why. Detailed logic.

 

[X82]

;1605809']On Sunday, September 23, 2012 11:10:37 PM UTC-5, X82 wrote:-

Hi guys.



I will try to explain this situation best I can.

I have about 500 .txt files. Here is a link to example files, 4 in

total.



https://docs.google.com/folder/d/0B0U_dFIXO1labHBPaXZKMWlSUGs/edit



The red parts of the files are the figure I need importing int excel.

So there is about 500 txt files with 4 different variations of the

file.



I also would like to import the filename of the txt file in a column So

column A would read, AMAB3.txt and column B would be the figur pulled

from the txt file, say 1.9 or 5.6 etc. In a long list.



I'm sorry if I've explained this terribly and I will try to clear u any

issues. All help on this matter is appreciated.

You could change from .rtf to .txt and then open in excel. Then yo
would need the logic of why 4.5 is the value you want from which fil
and why. Detailed logic.

The linked rtf files are only so I could append red marks fo
illustration purposes only. All 500 files are .txt files. How do yo
mean logic also

 

[Ron Rosenfeld]

The linked rtf files are only so I could append red marks for
illustration purposes only. All 500 files are .txt files.

How do you mean logic also?

Although I cannot be certain, there need to be some rules (logic) to follow so as to know which values to be extracted from each of the files. Other than being colored red (which you indicate is only for illustrative purposes, so won't occur in the original .txt file), there does not seem to be anyway to determine why you want the following values extracted from each of the files.

file 1: 4.5
file2: 1.3 6.0
file3: 5.5
file4: 5.7 5.0 3.9