{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/0557399df61b430c88ef0726c6321a35\" frameborder=\"0\" width=\"1152\" height=\"864\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":864,"width":1152,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":864,"thumbnail_width":1152,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/0557399df61b430c88ef0726c6321a35-00001.gif","duration":200.659,"title":"Domo Help: Extracting Text","description":"In 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."}