Home > IT Answers > Database > Find a string in text file using MS Access
masrawi2010
5 pts.
 Find a string in text file using MS Access
MS Access, Search string
I would like to read a multi-row text file, from inside MS Access, search for a string and returns all its occurences. Sample file: ------------ Patch 123456 : applied on Wed Jun 27 15:42:09 CEST 2009 Created on 23 Mar 2009, 00:48:16 hrs PST8PDT ... Patch 654321 : applied on Wed Jun 25 15:41:56 CEST 2009 Created on 23 Mar 2009, 00:48:01 hrs PST8PDT ... Sample output: -------------- I would like the VBA code to search for the string 'Patch' and returns the opposite patch number; for example'123456'. Thanks in advance

Software/Hardware used:
ASKED: July 10, 2012  11:11 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _