| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to extract data from an array | Excel Programming | |||
| Extract multiple values from array | Excel Discussion (Misc queries) | |||
| Extract a column/row from a 2-D array | Excel Programming | |||
| How do I extract a single value from the linest array result? | Excel Worksheet Functions | |||
| How do I extract hyperlink as text from an array of hyperlinks? | Excel Worksheet Functions | |||
Threaded Mode
