12 ms·
huh, TIL that regex wasn't a thing in vanilla excel. Thought that'd be a basic thing that's included.
by aronhegedus 2y ago
huh, TIL that regex wasn't a thing in vanilla excel. Thought that'd be a basic thing that's included.
- appleiigs 2y agoI realized that long ago... it's incredible that it took this long given how common it is in programming.
- axus 2y agoThe strategy of freezing VBA and BAT scripting, offering better alternatives, and hoping they'd go away on their own hasn't worked.
- layer8 2y agoYou can using VBA functions and VBScript.RegExp. This is restricted to Windows though. Microsoft wants to get rid of VBScript, so maybe they are going through the most common use cases in Excel.
- blowski 2y agoHave they officially said they want to get rid of VBScript?
- layer8 2y agoPretty much: https://techcommunity.microsoft.com/t5/windows-it-pro-blog/vbscript-deprecation-timelines-and-next-steps/ba-p/4148301 https://techcommunity.microsoft.com/t5/windows-it-pro-blog/v...
- sebazzz 2y agoYes, but that doesn't include getting rid of VBA. They probably do want to do that though, to allow mobile apps and web-based Excel to run interactive sheets using Javascript. Of course they've been trying for years to allow Javascript in Excel, but at least in the first versions that ran using Internet Explorer in the background. I'm not sure if that has evolved further now.
- wruza 2y agoYou never expect basic ergonomics from an ALL CAPS language. They all suck.