View Single Post
  #1   Report Post  
Old May 14th 19, 10:57 AM posted to microsoft.public.excel.programming
RG III RG III is offline
external usenet poster
First recorded activity by ExcelBanter: May 2019
Posts: 22
Default Tricky regular expression

Suppose I have the following string in a variable:

sLine = "abc G. James #000"

I'm only interested in extracting TWO fragments as follows:
The first extracted fragment should be "abc"
The second extracted fragment should be "G. James #000"

Is there a regular expression pattern that might be able to extract the above fragments?

In general, I'm trying to divide any input string into 2 pieces, and the dividing point is the first set of whitespaces that occur in the line. In the above example, the dividing point occurs right after the "abc".

Clear as mud? (Haha)