In this video, we will see if we can use the power of ChatGPT to solve a regex challenge in Tableau. Specifically, we will try to extract emails from a paragraph of text text using ChatGPT's advanced natural language processing capabilities. We will walk you through the process step-by-step. We will also provide tips and tricks for optimising your question in Chat GPT to improve the accuracy of its response and troubleshoot where necessary to make the calculation work. Whether you're new to using ChatGPT or a seasoned pro, this video will give you the knowledge and skills you need to confidently tackle any regex challenge in Tableau.
Rregex101: build, test, and debug regex https://regex101.com/r/0v0M6o/1
Additional Functions - Tableau https://help.tableau.com/current/pro/desktop/en-us/functions_functions_additional.htm
Data from mocker Mockaroo - Random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel https://www.mockaroo.com/bdcc6ce0
Timestamps
0:00 Intro
0:16 The challenge
2:49 Asking Chat GPT
4:53 testing the formula it gave us
6:31 Verdict on the response
7:11 Asking a better question
10:09 Can chat GPT explain the formula?
11:59 Using regex 101 to validate the formula