PDA

View Full Version : Extract string within tags



swaggerbox
11-19-2009, 01:15 AM
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?

xld
11-19-2009, 01:37 AM
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.