This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Here's a "quick" video explaining how I approach performance profiling. In exploring an Alteryx challenge (posted by @vineetamishra ) both @PhilipMannering and I provide solutions to the following post: Regex-extracting-after-last-underscore
Philip followed the instructions and responded with a RegEx expression:
REGEX_Replace([Example String], ".*_(.*)", '$1')
I followed with a nested string function:
Right([Example String],Findstring(ReverseString([Example String]),"_"))
Philip countered with a different string function (using getword()):
reversestring(getword(replace(ReverseString([example string]), '_', ' '), 0))
I followed with a "but mine is fastest" argument rebuttal.
How and why did I think that mine was fastest? Please watch (9 minutes) and find out! Please comment below on how you would test or give me any feedback.
Thank you to @vineetamishra and @PhilipMannering for your contributions.
Very interesting. Thank you for sharing.
The key highlight for all the people watching this. Regex is awesome but it takes up a lot of resources 😀