Solved using regex tool with parse output mode.
I learned a lot of things with this exercise, in particular, I utilized a site that I had heard before in one of Alteryx live training to test our regex dynamically:
An explanation of my regex can be seen below:
Let's have a look at my friends' solutions! :-)
Hope you are very well.
I just want to thank you a lot for this workflow!
My mind is bubbling with it. :-)
I got a Google API key (my first time using Google APIs) and I'm testing your workflow and finally, I am starting to understand when I have to use '?' in my regex.
In other words, I started understanding what is the difference between long.*?] and long.*]
Thank you so much for share your ideas here.