Find position of date in string
Hi Robert,
Am Wed, 9 Oct 2019 03:13:33 -0700 (PDT) schrieb RG III:
What's a good method for finding the position of the first date in a
string? In the above example, it starts at position 25.
try:
Const myStr = "The video shows that on 9/24/2019 the suspect entered the store."
i = InStr(myStr, "/")
myPos = InStrRev(myStr, " ", i) + 1
Regards
Claus B.
--
Windows10
Office 2016
|