Excel RegEx Support For Pattern Matching - Episode 2642

[@daXcel7448]

Thanks for the video. Flash Fill too does a pretty good job in these situations.

[@mangezable]

Fascinating! I held a lecture on regex to my colleagues two days ago, so this upload was a nice coincidence. Will be interesting to see this in Excel! 😊

[@roywilson9580]

Thanks for the video, I can't wait to get my hands on the Regex functions, having already used them in python and can see very many use cases with Excel in data cleansing and so on.

[@OmisileKehindeOlugbenga]

Awesome. RegEx now in Excel.

[@facthello2814]

I work for excel

[@vinamrachandra9611]

Grep, short for “global regular expression print”, was a command, I first encountered in Unix, used for searching and matching text patterns in files contained in the regular expressions.

[@Excelambda]

Great Video!! Do not have the update yet to check. 2:25 the difference could be : one way : all the digits should have at least one occurrence...and since there are digits with no occurrence...no match ; the other way zero or more occurrences

[@meniporat3527]

The problem in cell C13 (At 2:25) can be solved thus: =CONCAT(REGEXEXTRACT(B13,"\d*",1)) BTW, this formula: =CONCAT(REGEXEXTRACT(B13,"\d+",1)) ("+" instead of "*") will yield the same result

[@subjectline]

Regular Expressions in Excel, woohoo!

[@Corey_Bee]

I think validating a list of email addresses would be a great use case. The precise requirements can be a bit confusing if you go for perfection, but once you settle on the requirements, regex is a great way to validate against them.

[@vinamrachandra9611]

I tried with B 90210 and used =REGEXEXTRACT(H13,"\d*",1) RESULT spilled over 4 rows with first, second, and fourth returning blank and third returning 90210. Looks like REGEXTRACT is returning blank if pattern is not matched. That is why =REGEXEXTRACT(H13,"\d*") works only when number is at the start of the string. =CONCAT(REGEXEXTRACT(H13,"\d*",1)) is working. Either a bug or poor design.

[@DM-py7pj]

will it have same limitations as _VBScript_RegExp_55_ ? E.g., no LookBehinds, Named Capturing Groups etc

[@MrXL]

Not the expert, but my expert friends say the version in Excel now is much better than VBA.

[@brianxyz]

It has the functionalities you listed.

[@DM-py7pj]

@@MrXL thank you

[@DM-py7pj]

@@brianxyz Exciting news then. Thanks.

[@Graham-uc8es]

Regular expressions that potentially have an infinite number of matches should be avoided. \d* can potentially match an infinite number of empty strings. I suspect the way Microsoft have implemented means it stops at so many matches, so if number first it matches and then breaks after the infinite matches. When there is something before the number, the infinite matches come first. \d+ is a lot safer.