Regular Expression - To match a closest space after nth character

[Chlwls808]

Hi,
I'm trying to workout something and in need assistance on setting RegEx pattern.

What would the regular expression pattern be if I were to match a certain space in a string.

As an example, I have a string:

"Mary had a little lamb"

And I want to match the closest space to the left, after 20th character. This would be the space between the "e" and the "l". So far I have this (?<=\s) and I can't figure out anything else with it.

Thank you.

 

[Rick Rothstein]

What do you mean by "match the closest space"... do you want the position number of that space?

You said "I want to match the closest space to the left, after 20th character" and I note the words "after the 20th character" but your description of the space you want to match is before the 20th character, not after it... please clarify.

 

[Chlwls808]

Yes, I guess it does sound confusing. Apologize for that. I meant before the 20th character.

So, I'm a newbie in macro and I'm tackling something bit complex for my standard, but trying to do as much as I can on my own rather than asking the pro's here for the end result. Hence why the question became that way.

But where I'm stuck is a part where I'm I am trying to get the regular expression pattern to identify the nearest space so that I can add a delimiter, without breaking a whole-word, only when the string is 20th character and longer.

My expectation would be to get:

From	To
Mary had a little lamb	Mary had a little@lamb
London bridge is falling down	London bridge is@falling down
This little piggie	This little piggie

 

[Marc L]

Hi,​

​

no need RegExp as it is easily doable with VBA basics …​