I would like to read a multi-row text file, from inside MS Access, search for a string and returns all its occurences.
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
I would like the VBA code to search for the string 'Patch' and returns the opposite patch number; for example'123456'.
Thanks in advance
Ask a Question
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!