Excel Regex SEARCH Function

[Masum Mahdy]

Hi good people! I need to create a RegEx function that will work the same way Excel SEARCH or FIND function works.
For example, the SEARCH function returns the position of a part of text within a string.
I want a RegEx SEARCH function that will match a pattern and return the location of the pattern within a string.
Anybody can help, please?

 

[Masum Mahdy]

I hope this image will make my query clearer.

 

[Sufiyan97]

Hii

Still not clear, can you please explain with some examples.

 

[Masum Mahdy]

Hii

Still not clear, can you please explain with some examples.

Hi Sufiyan.
If I use the SEARCH function, it will detect exactly the input substring. But I need to return the position of a substring within the main string where the substring has a certain pattern, in order that if I change the substring, but keep the pattern the same as before, my desired RegEx function will consider it the same. To SEARCH function, AAA means AAA, and AAA is not the same as CCC. But my desired VBA RegEx function will consider AAA and CCC the same, because they have the same pattern, and this function will work just as the original SEARCH function does.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Excel REGEX SEARCH Function
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.