Prev: form that retrieves existing data from table and allows editin
Next: VBA to merge cells
From: Javed on 14 Oct 2009 13:29
Hi,
I have text file created by an application. I need to read that into excel. The structure of the text file is as follows:
(a) Several lines of text of equal length, with blank lines interspersed.
(b)A text line with headers identifying the data in that follows
(c)Several lines of data. This data in each line is tab delimited. Some data is text others are numbers
(d) The data lines are follwoed by at least one blank line

I then want to write the data columns selectively to another sheet. This selection would be based on the headers and the rows if the data in one of the columns (which is text) is not a certain alphabet.(say P).
Would appreciate help. Thanks

EggHeadCafe - Software Developer Portal of Choice
Play Embedded Sound Resources in .NET
http://www.eggheadcafe.com/tutorials/aspnet/5c08dbd8-0ad2-4a65-93c5-712cc8b24106/play-embedded-sound-resou.aspx
 | 
Pages: 1
Prev: form that retrieves existing data from table and allows editin
Next: VBA to merge cells