Challenge #476: Extract Operational Metrics from Your Workflow Logs

[barrymoe]

Good challenge!

[Yogesh1795]

Regex Challenges are the best one, However I used basic tools and logic to solve this

[Qiu]

I also can not match the answer provided with part 1.

Spoiler

[RWvanLeeuwen]

here's my take

Spoiler

I really dislike that my formula is dysfunctional --> Regex_Replace([Field_1], "Finished in ([\d\.:]+), '$1') fails to deliver the timestamp details and it follows through by basically giving me the full string

[RWvanLeeuwen]

Never mind: I just need to reboot Alteryx and then this stuff works again
Regex_Replace([Field_1], "Finished in ([\d\.:]+)(.*)", '$1')

IT Crowd https://www.youtube.com/watch?v=nn2FB1P_Mn8

[RolandSchubert]

Spoiler

[JBevan89]

I am working through trying to produce my solution.  But I have encountered an issue, which I am not sure any of the answers have solved yet (apologies if they have).  The duration for part 1 in the answer is Time format, and includes milliseconds.  I have been trying to convert the string output into Time format, but I am unable to perhaps because of the milliseconds.  I have version 2024.1, and also I can not seem to find where to set the workflow to allow milliseconds.  Otherwise with the use of AI, it will not accept different formulas like DateTimeParse, etc.  So appreciate if anyone knows how to accept milliesconds with the Time data type?

[JBevan89]

Finally found a Solution.  I needed to use "%H:%M:%S.%3"  instead of %H:%M:%S.%f

[JBevan89]

Spoiler

 

[Tofel]

Spoiler