REGEX
Discussion List
-
Any Way to Use Regular Expressions to Change Case of Specific WordsI've got a requirement to change the appearance of articles and prepositions in words in a column t… -
Regex Replace IssueHello, I'm trying to do a regex replace to grab a combination of letters and digits but throw out t…
-
Reg Ex difficultyI am attempting to pull out a string using Reg ex. I want to get the card name, so text after the …
-
Using RegEx to Extract DateHi all! I am looking for advice on extracting a Maturity Date from a column containing a string of … -
Split varying full names into First Name, Middle Name, and Last NameHi there, Back with another question. I have a Full Name column in varying format: Alex McCandless…
-
Parsing Dates with Different FormatsDoes anyone have any guidance for using a formula/function in a beast mode or using the regex funct…
-
REGEXP_REPLACE in ETL add new line?I have data in Domo for an address that includes a new line character. This data was brought in fr…
-
Reg. Expression to replace a list of names with a single character.I have a column that is in a string format, and of course contains names. Majority of the rows are … -
Regex Filters in Google Analytics?Hello! I saw another post on this but I don't think that's what I was looking for. I'm trying to bu…
-
How to delete portion of text in a column in the ETL?I have a date column that is in this format: The format of the date is fine, but what I am trying …
-
Finding characters in a string and extracting the characters plus 4 more charsWe have a table that contains the Subject line of every email in our distribution list. I'm trying…
-
Which Redshift SQL version / functions are supported?Hey ya'll, I'm trying to write query to do a Regex sub string on some text. Beast Mode and Magic E…
-
Magic ETL Trim left of decimalI noticed there isn't a ton (easily found) info on the different Regex to use to trim off data. …Answered ✓ Closed Canioagain 46 views 2 comments 1 point Most recent by codysirwin Scheduled Reports
