Several months ago I posted a thread about searching and retrieving a string. This thread was solved... thx for all the help. Refer to the following link => http://www.excelforum.com/access-pro...h-pattern.html
In this new thread I'm trying to achieve two (2) tasks that are very similar.
I have a column in MS Access 2003 named 'Application_XML'. Each cell per record contains about 700 lines of details. See below for sample of cell:
1. How do I retrieve the value for 'LANGUAGE_SPOKEN'? which in the sample is 'EN'HTML Code:
2. How do I retrieve what the user has entered in Notes? which begins with the tag '<Notes>' and ends with the tag '</Notes>'
Eventually, I will have the Language_Spoken value and any Notes in its own column in an Access query.
Please help !
Bookmarks