Click here to Skip to main content
15,867,568 members
Home / Discussions / Regular Expressions
   

Regular Expressions

 
GeneralRe: Sometimes its a bullet item, sometimes it is not, sometimes it is multiple bullet items Pin
Member 158838933-Jan-23 23:14
Member 158838933-Jan-23 23:14 
QuestionRegEx- Find files in Linux which match the expression Pin
JDMils3-Jan-23 16:16
JDMils3-Jan-23 16:16 
AnswerRe: RegEx- Find files in Linux which match the expression Pin
Richard MacCutchan3-Jan-23 21:32
mveRichard MacCutchan3-Jan-23 21:32 
AnswerRe: RegEx- Find files in Linux which match the expression Pin
k50544-Jan-23 9:12
mvek50544-Jan-23 9:12 
GeneralRe: RegEx- Find files in Linux which match the expression Pin
JDMils8-Jan-23 12:56
JDMils8-Jan-23 12:56 
QuestionRegular Expression to find parts of a <script/img src=""> or <link href=""> attribute value Pin
Steve M Penner3-Jan-23 5:13
Steve M Penner3-Jan-23 5:13 
QuestionParsing Session Campaign Data in Data Studio Pin
Michael Oct20223-Jan-23 3:16
Michael Oct20223-Jan-23 3:16 
I am trying to create a formula in Data Studio using RegEx that extracts the channel from the below URLs, all channels are passed as the first value before the first _

ppcnonbrand_sports_uk_google_ourwebsite_b5g5_onlinebetting
crm_sports_uk_email_ourwebsite_b5g5_welcomeemail4b_signin_0_0_0
crm_sports_uk_email_ourwebsite_superboost_221206crmuksportstuenewsletterb_bethere_221206_rnd_0
socialbrand_sports_uk_facebook_ourwebsite_none_carouselawareness_23852435274560534_23852435274610534_0_Facebook_Desktop_Feed_23852435274780534

so from the above i want to return:

ppcnonbrand
crm
socialbrand 

I have tried the following but it only returns "null" for everything .. i'm all out of ideas, can anyone suggest something?

REGEXP_EXTRACT(Session Campaign, "^[^_]*")

AnswerRe: Parsing Session Campaign Data in Data Studio Pin
Michael Oct20223-Jan-23 5:01
Michael Oct20223-Jan-23 5:01 
QuestionNeed a bit of help concerning RegEx Pin
Regis Maltais 202112-Dec-22 23:42
Regis Maltais 202112-Dec-22 23:42 
AnswerRe: Need a bit of help concerning RegEx Pin
OriginalGriff12-Dec-22 23:47
mveOriginalGriff12-Dec-22 23:47 
QuestionWhy does this work but this doesn't Pin
Andrew St. Hilaire26-Nov-22 16:52
Andrew St. Hilaire26-Nov-22 16:52 
QuestionRe: Why does this work but this doesn't Pin
k505426-Nov-22 17:30
mvek505426-Nov-22 17:30 
AnswerRe: Why does this work but this doesn't Pin
Andrew St. Hilaire26-Nov-22 17:51
Andrew St. Hilaire26-Nov-22 17:51 
AnswerRe: Why does this work but this doesn't Pin
Richard Deeming27-Nov-22 22:11
mveRichard Deeming27-Nov-22 22:11 
AnswerRe: Why does this work but this doesn't Pin
jschell28-Nov-22 10:42
jschell28-Nov-22 10:42 
QuestionHow to remove an & in the following expressions Pin
Victor Nijegorodov21-Nov-22 8:31
Victor Nijegorodov21-Nov-22 8:31 
AnswerRe: How to remove an & in the following expressions Pin
k505421-Nov-22 10:21
mvek505421-Nov-22 10:21 
GeneralRe: How to remove an & in the following expressions Pin
Victor Nijegorodov22-Nov-22 3:32
Victor Nijegorodov22-Nov-22 3:32 
AnswerRe: How to remove an & in the following expressions Pin
Richard MacCutchan21-Nov-22 21:50
mveRichard MacCutchan21-Nov-22 21:50 
GeneralRe: How to remove an & in the following expressions Pin
Victor Nijegorodov22-Nov-22 2:41
Victor Nijegorodov22-Nov-22 2:41 
GeneralRe: How to remove an & in the following expressions Pin
Richard MacCutchan22-Nov-22 3:13
mveRichard MacCutchan22-Nov-22 3:13 
GeneralRe: How to remove an & in the following expressions Pin
Victor Nijegorodov22-Nov-22 3:59
Victor Nijegorodov22-Nov-22 3:59 
AnswerRe: How to remove an & in the following expressions Pin
Victor Nijegorodov22-Nov-22 4:05
Victor Nijegorodov22-Nov-22 4:05 
QuestionRegex search to find and remove consecutive lines which end with same characters Pin
Member 1582987913-Nov-22 5:05
Member 1582987913-Nov-22 5:05 
AnswerRe: Regex search to find and remove consecutive lines which end with same characters Pin
jschell14-Nov-22 6:43
jschell14-Nov-22 6:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.