Click here to Skip to main content
15,562,816 members
Home / Discussions / Regular Expressions
   

Regular Expressions

 
GeneralRe: How to remove an & in the following expressions Pin
Richard MacCutchan22-Nov-22 4:13
mveRichard MacCutchan22-Nov-22 4:13 
GeneralRe: How to remove an & in the following expressions Pin
Victor Nijegorodov22-Nov-22 4:59
Victor Nijegorodov22-Nov-22 4:59 
AnswerRe: How to remove an & in the following expressions Pin
Victor Nijegorodov22-Nov-22 5:05
Victor Nijegorodov22-Nov-22 5:05 
QuestionRegex search to find and remove consecutive lines which end with same characters Pin
Member 1582987913-Nov-22 6:05
Member 1582987913-Nov-22 6:05 
AnswerRe: Regex search to find and remove consecutive lines which end with same characters Pin
jschell14-Nov-22 7:43
jschell14-Nov-22 7:43 
QuestionRemoving + - chars if lines are starting with them only Pin
montaigne gremo2-Nov-22 3:32
montaigne gremo2-Nov-22 3:32 
AnswerRe: Removing + - chars if lines are starting with them only Pin
jschell14-Nov-22 7:39
jschell14-Nov-22 7:39 
QuestionFind the 4th last object in this campaign Pin
Michael Oct202220-Oct-22 4:05
Michael Oct202220-Oct-22 4:05 
My campaigns all follow the same naming convention, i am trying to use a Regex_Extract formula in DataStudio to create a new custom dimension that only displays the 4th last element in the below campaign: "ctatext"

Each element is separated by a _

channel_product_country_medium_brand_offer_campaignname_ctatext_date_objective_0


Closest i have gotten is:
REGEXP_EXTRACT(Session campaign, '(.+){4}(?:[^_]+.)')


but that only returns the 4th character in the string .. can anyone help ?
AnswerRe: Find the 4th last object in this campaign Pin
Richard Deeming20-Oct-22 5:28
mveRichard Deeming20-Oct-22 5:28 
GeneralRe: Find the 4th last object in this campaign Pin
Michael Oct202220-Oct-22 6:04
Michael Oct202220-Oct-22 6:04 
QuestionSplitting with optionally second line Pin
G-Team2329-Sep-22 3:47
G-Team2329-Sep-22 3:47 
AnswerRe: Splitting with optionally second line Pin
Richard Deeming29-Sep-22 4:11
mveRichard Deeming29-Sep-22 4:11 
GeneralRe: Splitting with optionally second line Pin
G-Team2330-Sep-22 1:19
G-Team2330-Sep-22 1:19 
QuestionIs there a way to come up with a regular expression for this? Pin
fame_crane23-Sep-22 5:28
fame_crane23-Sep-22 5:28 
AnswerRe: Is there a way to come up with a regular expression for this? Pin
Gerry Schmitz23-Sep-22 6:56
mveGerry Schmitz23-Sep-22 6:56 
Questionremove parenthese from function like string Pin
Michael Eckstein17-Sep-22 9:56
Michael Eckstein17-Sep-22 9:56 
AnswerRe: remove parenthese from function like string Pin
moxol17-Sep-22 11:43
moxol17-Sep-22 11:43 
GeneralRe: remove parenthese from function like string Pin
Michael Eckstein18-Sep-22 5:55
Michael Eckstein18-Sep-22 5:55 
GeneralRe: remove parenthese from function like string Pin
moxol18-Sep-22 8:28
moxol18-Sep-22 8:28 
GeneralRe: remove parenthese from function like string Pin
Michael Eckstein18-Sep-22 9:01
Michael Eckstein18-Sep-22 9:01 
GeneralRe: remove parenthese from function like string Pin
moxol18-Sep-22 10:19
moxol18-Sep-22 10:19 
GeneralRe: remove parenthese from function like string Pin
Michael Eckstein18-Sep-22 21:22
Michael Eckstein18-Sep-22 21:22 
QuestionRegex to find out length Pin
RanCohen16-Aug-22 0:50
RanCohen16-Aug-22 0:50 
AnswerRe: Regex to find out length Pin
Richard Deeming16-Aug-22 1:14
mveRichard Deeming16-Aug-22 1:14 
AnswerRe: Regex to find out length Pin
Graham Breach16-Aug-22 3:12
Graham Breach16-Aug-22 3:12 

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.