View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
dpb dpb is offline
external usenet poster
 
Posts: 109
Default Extract segments of an array

On 2/8/2021 10:46 AM, Claus Busch wrote:
Hi,

Am Sat, 6 Feb 2021 23:06:11 -0800 (PST) schrieb Tatsujin:

Hi Claus. Do you know how to modify that regex pattern so that it grabs the entire string after the first matched letter?

So, if mysort(1) = "Andy is in Room #29.", then myarray(0) should have "Andy is in Room #29."


RegExp is for searching words or substrings in a text but not for
searching sentences.


For limited definitions of what constitutes a sentence it can be done.
One stackoverflow submission of many.
<https://stackoverflow.com/questions/5553410/regular-expression-match-a-sentence

--