Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #111182

Re: Find position of date in string

Newsgroups microsoft.public.excel.programming
Date 2019-10-09 12:01 -0700
References <da45bc2b-80a4-4890-85c4-be164592a39c@googlegroups.com> <qnkgvo$89l$1@dont-email.me>
Message-ID <9ca26d2d-4af2-4908-bc67-e3704fe80cab@googlegroups.com> (permalink)
Subject Re: Find position of date in string
From RG III <mob.rrr.3@gmail.com>

Show all headers | View raw

> 
> Const myStr = "The video shows that on 9/24/2019 the suspect entered
> the store."
> 
> i = InStr(myStr, "/")
> myPos = InStrRev(myStr, " ", i) + 1
> 
> 

I suppose that works.  It appears to just find the first "/" character
in a string, is that right?

And BTW, I made a typo in my above message.  The format of the
dates is "m/dd/yyyy" or "mm/dd/yyyy".

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Find position of date in string RG III <mob.rrr.3@gmail.com> - 2019-10-09 03:13 -0700
  Re: Find position of date in string Claus Busch <claus_busch@t-online.de> - 2019-10-09 13:40 +0200
    Re: Find position of date in string RG III <mob.rrr.3@gmail.com> - 2019-10-09 12:01 -0700
      Re: Find position of date in string dpb <none@none.net> - 2019-10-09 20:29 -0500

csiph-web