REGEX

Hi everyone, I wanted to create this discussion post to share a methodology I created using Domo's Regular Expressions in Magic ETL to parse and validate US phone numbers. This validation process follows the basic standards set by the North American Numbering Plan (NANP) and helps identify valid US phone numbers from a…

I am trying to extract two different sets of numbers from a string. I have tried substring and Regexp, but to no avail. Examples of the stringss- Possible string format #1 Company Name - 2024-07-01-2024-07-31 - GPPC - YTUBE - VYT - 63784 - 2782837 - 458573682 - [745-000121-003] Possible string format #2 Company Name -…

REGEX functions are currently supported in the MagicETL formula tiles, but not in beast mode. It would be helpful to have these added to Beast Mode.

Hello, I need some help pulling out email addresses from a text string. My goal is to place these multiple emails listed in the 'Description' column in a separate column, where they'll be separated by ','. Is there way for the search to end before the Sent Date info? Thank you!

I currently am working with a column that is delimited using underscores. I was able to write the following RegEx in a builder which was able to do what I needed: ^(?:[^_]+) What is the best way to implement this RegEx to return the part of the string that this captures?

Hello! I know variations of this question have been asked in the forums but I haven't been able to find a solution that works for me. I have a column Project Name that contains Projects out of Financial Force that may contain an At-Risk ticket number, which is formatted as: AR-00000 i.e. literally "AR-" or "AR - " followed…

I have rows that look like this: Interview with Bob Dylan - CSM and want to parse just the CSM. I tried using Replace Text file, selecting reg ex and using this: -.* but it returned the former portion. Any recommendations on what reg ex to use?

Hello I need some help pulling out T#### and some T####.### from text string. REGEXP_LIKE('text','/T[0-9]+.?[0-9]+/g', 'n') I am trying to pull the T# out of the following text string and place them in a different column. Data Exfiltration via DNS|T1048.003|T1071.004|T1572 I have multiple rows with different T#'s…

Does anyone know how to create a Regex that only accepts a segment with a number before a 'k' and nothing after? Or it can be a regex that replaces everything that doesn't have a number before 'k' and nothing after with an empty string. I am looking to extract the circ value for our email campaigns but some rows have a…

Can anyone help me with Regex for an email connector. I have an email with two separate xlsx files. I've noticed the email connector will automatically default to the first one and I'm having difficulty getting a connector to pull the other. I tried setting up a separate connector to pull a file if the Attachment name…

Hi all, I need to split a column that contains both a client name and number into 2 separate columns. Some client names themselves contain whitespace, so I cannot split on whitespace and am looking at Regex, though it's been a while since I've used it. All the client numbers are 5 digits long, though they are randomly…

I've got a requirement to change the appearance of articles and prepositions in words in a column to be displayed as lowercase after running a Title Case on the rest of the phrase. Right now, I have an extensive list of text replacements in Magic ETL to do this, but I was wondering if there might be a way to do this with a…

Hello, I'm trying to do a regex replace to grab a combination of letters and digits but throw out the rows where I don't get anything. Here is my formula: case when REGEXP_LIKE(`Asset name`,'^.*([a-z]{4,5}\d{6}).*$')=1 THEN REGEXP_REPLACE(`Asset name`,'^.*stc=?([a-z]{4,5}\d{6}).*$','$1') else NULL end To explain, I'm…

I am attempting to pull out a string using Reg ex. I want to get the card name, so text after the --- card_name: and between measurable_id. I am using .*measurable_id) but it is giving me an error message?

Hi all! I am looking for advice on extracting a Maturity Date from a column containing a string of text, example: string: 12months,MATURITY DATE:23-Jun-2022,BALANCE;$12345,PRODUCT Return: 23-Jun-2022 I am able to successfully select the date by using: \d{2}-[A-z]{3}-\d{4} But am unable to replace this so that it only…

Hi there, Back with another question. I have a Full Name column in varying format: Alex McCandless Alexander David Thoreau Bobby Del Rio Cameron Diaz Camilo Carter Dave O'Donald Jack E. Topez ... and I need to parse this into three columns: First Name - the first word of the string, seems easily accomplished with the split…

Does anyone have any guidance for using a formula/function in a beast mode or using the regex functionality to ensure Domo recognizes all of the dates below as the same? 5/12/2022 5/12/22 2022-05-12 5.12.2022 5.12.22

I have data in Domo for an address that includes a new line character. This data was brought in from NetSuite in this format. I am trying to add additional data that matches this format. I have the following data: Ship Address: attn~company~addr1~addr2~city, state zip I would like it saved as such: attn company addr1 addr2…

I have a column that is in a string format, and of course contains names. Majority of the rows are an empty string. What I am looking for is to take the rows that do contain a name and replace them with a 1. i have been trying to use replace text tile then trying to use a regular expression in the 2nd step, then replace…

Hello! I saw another post on this but I don't think that's what I was looking for. I'm trying to build a regex filter for the Google Analytics connector and I'm wondering how I can exclude a certain regex statement. This is what I have so far but I'm actually not sure what the operator should be. This filter is supposed to…

ToDo: Use an Edit Data --> Replace Text action in the workflow. Select Regex option and replace by empty string. You can also replace the match with any string you require. Get Handles: (^|\s|[^@\w])+[^@\s]+ Example: Hi @Something how are @you doing David. Result: @Something @you Get Hastags: (^|\s|[^#\w])+[^#\s]+ Example:…

I have a date column that is in this format: The format of the date is fine, but what I am trying to do is get rid of everything including the 'T' and to the right, so that all that is left would be 2021-06-27. If a solution within the ETL is possible that would be great.

We have a table that contains the Subject line of every email in our distribution list. I'm trying to extract our reference number and put it in another column. For now, our ref# starts with an 876 or 877 and it's 7 digits long. I used a CASE-WHEN-LIKE to identify the lines that contain 876 or 877 and minimize the lines I…

Hey ya'll, I'm trying to write query to do a Regex sub string on some text. Beast Mode and Magic ETL have Regex but not Regex sub string. MySQL has the capability but Domo is on version 5.x~. My last option was Redshift SQL. My query: SELECT SUBSTRING_REGEX("Description", '.*(Red).*') as color from "clothing_db" Error: The…

I noticed there isn't a ton (easily found) info on the different Regex to use to trim off data. My use case was I had a file using a numbering system before a product. So instead of saying Lowe's, Home Depot, Walmart it would sayd 1.Lowes, 2. Home Depot, and 3. Walmart. I found some regex that drops the period and what's…