In E:\test folder, I have several text files. Each text file contains several datasets. What I need to do is extract the string within and tags and output these to Excel. The extraction part gives me so much difficulty. Is there a simple way to extract the string within these tags?
If youy lookup Instr in VBA help you will find this finds the position of a nominated string (Character), so you can use this in conjunction with Left or Mid to extract between tags.
Last edited by Bob Phillips; 11-19-2009 at 01:51 AM.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
