peskywinnets
Registered User.
- Local time
- Today, 05:00
- Joined
- Feb 4, 2014
- Messages
- 576
I have a text file that I'm reading into Access with VBA.
The first line of the text file will always follow this format )(though obviously the dates will change)...
Transaction Summary for 10 April 2018 to 18 April 2018
The to in that line will always be a constant (& the date I wish to extract will always follow on from it), so I seek a creative VBA way to capture all that follows the to in the line of text. Therefore I will end up with this...
18 April 2018
Which I can then trim & act upon to convert the text into a short date format (I know how to do this bit!)
What's the VBA function I can best deploy to trap the to & capture all the text that follows please?
Many thanks!
The first line of the text file will always follow this format )(though obviously the dates will change)...
Transaction Summary for 10 April 2018 to 18 April 2018
The to in that line will always be a constant (& the date I wish to extract will always follow on from it), so I seek a creative VBA way to capture all that follows the to in the line of text. Therefore I will end up with this...
18 April 2018
Which I can then trim & act upon to convert the text into a short date format (I know how to do this bit!)
What's the VBA function I can best deploy to trap the to & capture all the text that follows please?
Many thanks!