regexlooker-studiore2
Need to use regex to extract a part of a string
I'm a regex noob that's trying to use the regexp_extract() function in data studio to extract part of a string. Could you help me out?
I need to extract the part of the string that comes after 'May'. Everything before 'May' is exactly the same across all campaigns.
I've tried googling the solution and killed a lot of time on regexer.com but i can't figure it out
Current Campaign Name:
Xxxxx_xxxxx_PKN_Trueview_24th MayComedy Movie Fans18-24
Xxxxx_xxxxx_PKN_Trueview_24th MaySouth Asian Film Fans18-24
Xxxxx_xxxxx_PKN_Trueview_24th MayCricket Enthusiasts18-24
Xxxxx_xxxxx_PKN_Trueview_24th MayMotorcycle Enthusiasts18-24
Expected Campaign Names:
Comedy Movie Fans18-24
South Asian Film Fans18-24
Cricket Enthusiasts18-24
Motorcycle Enthusiasts18-24
EDIT: I'm trying to use this in data studio in the REGEXP_EXTRACT(Campaign,"regex_code_here") function. I think the acceptable syntax is re2.
Solution
You may actually use REGEXP_REPLACE here to remove all before and including May:
REGEXP_REPLACE(Campaign, '.*May', '')
See the regex demo:
- extract string emojis from text
- gawk hangs when using a regex for RS combined with reading a continuous stream from stdin
- notepad++ regex mode: insert new line to some hex code
- Replace all image urls with <img> tags
- Regex Greedy from right to left
- Get all integers which follow certain symbols in a string with multiple delimiters
- How do I check if a filename matches some wildcard pattern?
- Replace named captured groups with arbitrary values in Python
- .htaccess redirect from site root to public folder, hiding "public" in URL?
- Program to generate regex easily?
- What's the regular expression that matches a square bracket?
- Add a new class to img tag's class list
- Wrap <img> tag in a new tag and add alt attribute to the <img>
- Remove non-<img> tags from string
- Remove excess newlines/whitespace from multi-line <img> tag in HTML string
- Get whole img tag including its attribute declarations from a string
- regex for match all <img> tag and extract the "src" attribute
- Trying to match src part of HTML <img> tag Regular Expression
- Find and kill a process in one line using bash and regex
- RegEx problem or maybe another solution altogether?
- Regex split where \# splits and \\# does not
- textfield text (one or more than one) regex check Swift UIKit
- Get the src value from all img tags
- How to extract img src, title and alt from html using php?
- Regular Expression to validate a CAGE Code
- Get telephone number from a string containing labelled contact details
- String matches method - forward slash not working
- How to make a REGEX pattern in mysql for 3 or more digits that are in sequence?
- Regex pattern with optional segments failing to match slash-delimited string
- Validate that a string is wholly alphanumeric and has a qualifying length