MarqueeCReW Quick Lesson: Performance Profiling

[MarqueeCrew]

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.

Cheers,

Mark

Spoiler

Bcc:  @NeilR@TuvyL@LeahK

[Emil_Kos]

Hi @MarqueeCrew,

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 😀