video1.0<iframe src="https://www.loom.com/embed/0557399df61b430c88ef0726c6321a35" frameborder="0" width="1152" height="864" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>8641152Loomhttps://www.loom.com8641152https://cdn.loom.com/sessions/thumbnails/0557399df61b430c88ef0726c6321a35-00001.gif200.659In this video, I address a question from N. Doyle about extracting a specific part of a string. The question involves a column called "project name" that contains projects from a financial source, some of which may include an "at risk" ticket number formatted as "AR" followed by a number. The viewer has tried using the "replace" function with regex but hasn't been able to preserve the "AR" ticket number while dropping the remaining text. I provide an alternative solution without regex, demonstrating how to make the "project name" consistent and extract the desired part using the "replace" and "left" functions. Action: Watch the video to learn how to solve this problem without regex.