Remove first and last letter using regex

[YasserKhalil]

Hello everyone

I have a string say [email protected]
I can use the usual functions to get rid of the first letter and the last letter before the symol @ so as the result would be [email protected]
But I need a regex pattern that would do that

Thanks advanced for help

[Marc L]

Hi Yasser !

I'm too lazy today to play with Regex as it needs a single codeline with the VBA text functions …

[YasserKhalil]

Thanks a lot. I tried this pattern but doesn't work for me

Please Login or Register  to view this content.

I know well how to use the VBA functions but I am training on regular expressions so thanks a lot.

[YasserKhalil]

I am trying to get the two groups

Please Login or Register  to view this content.

Each group works well lonely but when use the two groups together I didn't get the both of them

[YasserKhalil]

I could use this pattern and when trying the code to extract all the matches I got the desired results

Please Login or Register  to view this content.

How can I remove those matches?
This is the code

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

[YasserKhalil]

Amazing my tutor jindon. That's exactly what I am trying to do...You did it magically
But I need to get the pattern .. Can you please give it a simple explanation?

[jindon]

Match to any one character at the beginning or any one character followed by @.

[YasserKhalil]

Thanks a lot. What does this symbol mean (?=@). What's the question mark refer to? Does this mean not to include the @ symbol

[jindon]

Open bracket with a question mark will avoid back reference of the grouped string up to closing bracket.

[YasserKhalil]

Sorry this is beyond my thinking. What do you mean by avoiding back reference?

[jindon]

What do you know about regular expressions?
If you want to learn it, google it for yourself first.
I don't want to explain from the very basics, sorry.

[YasserKhalil]

I already read about it .. and here's the tutorial I have read
https://stackoverflow.com/questions/22542834/

and the question mark means( Match zero or one of the pattern defined before it.)
but I am confused about using the equal sign and the brackets.

[Marc L]

Yasser,

on my profile messages you asked for a sample using Evaluate but I won't use it for your need as described,
just the VBA text functions for a single codeline …

[YasserKhalil]

Thanks a lot, Mr. Marc for your sharing. I like you to share absolutely.