I get ASSERTION FAILED using VBSCRIP RegEx

Question

I get this error using Web and app.

Answer 1

Hi @Claudio Pratella, 

Thank you for your prompt update. I've tried the pattern you provided and in my test device the result turns out that it still works properly in my Excel version.  

However, according to your sharing, the issue happens after a recent update, and everything has worked normally until then. It's a right way to suspect whether it's a new issue with version updates but currently there has not been any official notifications about this issue from Microsoft. For now, we suggest you can try downgrade Excel to older version to see it still works well there and also prevent the negative effect of the issue to your workflow. You can follow these steps: 

Step 1: Download and Extract ODT 

• Download the .exe file from Download Office Deployment Tool from Official Microsoft Download Center 
• Run it to extract two files: setup.exe and configuration.xml (sample) 

Step 2: Create Your Custom Configuration File 

• Open Notepad and paste the following XML: 

<Configuration>  

<Updates Enabled="TRUE" TargetVersion="16.0.xxxxx.yyyyy" />  

</Configuration> 

• Replace TargetVersion with the exact build number for previous version like version 2507. You can find this from Update history for Microsoft 365 Apps (listed by date) - Office release notes | Microsoft Learn. 
• Save the file as Config.xml in the same file location as the Setup.exe file 

Step 3: Run the Installer 

• Open Command prompt as administrator, navigate to the folder where setup.exe and your XML file are located, then run: 

setup.exe /configure config.xml 

• This will install the specified version of Office/Excel. 

Step 4: Disable auto updates (Optional) 

• Open Excel. 
• Go to File > Account > Update options. 
• Select Disable updates to prevent reverting to newer versions. 

For more detailed guideline, you can refer to How to revert to an earlier version of Office - Microsoft Support

Additionally, I strongly recommend submitting in-app feedback so that your experience can be formally logged with our engineering team. You can do this from Excel > Help > Feedback or go to Microsoft 365 Feedback Hub > send feedback. 

For now, I highly recommend accepting this answer as well. That way, other users who encounter the same question will see the clarification, and more of them may report similar problem, helping to bring attention to the request. The more reports the team receives, especially from business users, the faster issues like this can be prioritized and resolved as soon as possible. 

I know this is not the experience you expected, and I want to thank you for your patience while the team works on improvements.  

Thank you for your understanding and corporation. Please let me know if there's anything else I can help you with. 

Looking forward to your response.

---

 If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread

Answer 2

I used the pattern you used and also in my case it worked, but Regular Expressions are used for complex situations and I use, by far, more complex patterns.

I tried a bit more complex pattern:

"\b(the|-|an|this|that|those|these)\b(?= is)"

and I received same error.

Answer 3

Same issueDim mRegExp As Object

1. Dim mMatches As Variant
2. Set mRegExp = CreateObject("VBScript.RegExp")
3. With mRegExp
4. .Global = True
5. .Pattern = "((?=[0-9])\b(13[0-9]|14[5|7|9]|15[0-3|5-9]|166|17[1-8]|18[0-9]|19[1|3|5|8-9])[\s]\d{4}[\s]\d{4}(?![0-9]))|((?=[0-9])\b(13[0-9]|14[5|7|9]|15[0-3|5-9]|166|17[1-8]|18[0-9]|19[1|3|5|8-9])\d{8}(?![0-9]))|(0(\d{3}-|\d{2}-))?(\d{8}|\d{7})(?!\d)"
6. Set mMatches = .Execute(Target.Value)
7. End With
8. Set mRegExp = Nothing
9. If mMatches.Count > 0 Then MsgBox mMatches(mMatches.Count - 1)

Previous version no this problem