3 ms·

I'll be honest, I didn't read the full feature list. I looked at some of the quick queries and was really happy to see some of them. Yeah, the amount of intell

I'll be honest, I didn't read the full feature list. I looked at some of the quick queries and was really happy to see some of them. Yeah, the amount of intellectual violence I'll be able to perpetrate against my data is just staggering. Regex in Excel has always be a bit of a slog, but to do it in SQL in Excel? Gosh. That's almost worth the price of adminssion right there. (Ever try to conditionally refactor a screwy OPC itempath based on an arbitrary spec and bad naming conventions in a cobbled together dump from an overworked customer engineer? Swiss army chainsaws are the only elegant solution there.)

anakic 10y ago
Exactly, you can really go to town on your data, get nasty with it:) I love regex myself, I feel like a ninja using them:) The replacex function was one of the first ones I implemented. Regex_split is the latest one and I love it (the single post on the QueryStorm blog is about that one). If you're .NET-savvy, check out the "eval" function, you can implement a function as a C#-like lambda expression. I did a poor job explaining what the plugin can do, QuickQueries is a step in that direction, but I only prepared a few. Plus they need short videos or at least blog posts to go along with them.