New to regex and using it for a project. Need help with a regexp replace statement. Any ideas?
Multi tool use
Clash Royale CLAN TAG#URR8PPP
up vote
0
down vote
favorite
Need help returning a string "Great Wolf Items" case insensitive that also accounts for a space or underscore between words.
I tried (GreatwWolfwitem*s)/i but it won't work in the tableau software I'm using.
regular-expression
edited Jun 15 at 8:42
roaima
39.2k544105
asked Jun 14 at 16:27
John Christopher
1
add a comment |Â
up vote
0
down vote
favorite
Need help returning a string "Great Wolf Items" case insensitive that also accounts for a space or underscore between words.
I tried (GreatwWolfwitem*s)/i but it won't work in the tableau software I'm using.
regular-expression
edited Jun 15 at 8:42
roaima
39.2k544105
asked Jun 14 at 16:27
John Christopher
1
1
What regex engine / flavor are you using, and what have you tried?
– steeldriver
Jun 14 at 16:32
I am using it within tableau software. I tried (GreatwWolfwitem*s)/i to include the case insensitivity and space, underscore, or character but it won't work.
– John Christopher
Jun 14 at 16:46
I'm not familiar with this software. What type of Regex does its documentation say it uses? (Abbreviations like ERE or PCRE would be good.)
– roaima
Jun 15 at 8:40
1
You talk about replacement in the title, but the question itself does not mention this.
– Kusalananda
Jun 15 at 9:00
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
Need help returning a string "Great Wolf Items" case insensitive that also accounts for a space or underscore between words.
I tried (GreatwWolfwitem*s)/i but it won't work in the tableau software I'm using.
regular-expression
edited Jun 15 at 8:42
roaima
39.2k544105
asked Jun 14 at 16:27
John Christopher
1
Need help returning a string "Great Wolf Items" case insensitive that also accounts for a space or underscore between words.
I tried (GreatwWolfwitem*s)/i but it won't work in the tableau software I'm using.
regular-expression
edited Jun 15 at 8:42
roaima
39.2k544105
asked Jun 14 at 16:27
John Christopher
1
edited Jun 15 at 8:42
roaima
39.2k544105
edited Jun 15 at 8:42
roaima
39.2k544105
edited Jun 15 at 8:42
roaima
39.2k544105
39.2k544105
asked Jun 14 at 16:27
John Christopher
1
asked Jun 14 at 16:27
John Christopher
1
asked Jun 14 at 16:27
John Christopher
1
1
1
What regex engine / flavor are you using, and what have you tried?
– steeldriver
Jun 14 at 16:32
I am using it within tableau software. I tried (GreatwWolfwitem*s)/i to include the case insensitivity and space, underscore, or character but it won't work.
– John Christopher
Jun 14 at 16:46
I'm not familiar with this software. What type of Regex does its documentation say it uses? (Abbreviations like ERE or PCRE would be good.)
– roaima
Jun 15 at 8:40
1
You talk about replacement in the title, but the question itself does not mention this.
– Kusalananda
Jun 15 at 9:00
add a comment |Â
1
What regex engine / flavor are you using, and what have you tried?
– steeldriver
Jun 14 at 16:32
I am using it within tableau software. I tried (GreatwWolfwitem*s)/i to include the case insensitivity and space, underscore, or character but it won't work.
– John Christopher
Jun 14 at 16:46
I'm not familiar with this software. What type of Regex does its documentation say it uses? (Abbreviations like ERE or PCRE would be good.)
– roaima
Jun 15 at 8:40
1
You talk about replacement in the title, but the question itself does not mention this.
– Kusalananda
Jun 15 at 9:00
1
1
What regex engine / flavor are you using, and what have you tried?
– steeldriver
Jun 14 at 16:32
What regex engine / flavor are you using, and what have you tried?
– steeldriver
Jun 14 at 16:32
I am using it within tableau software. I tried (GreatwWolfwitem*s)/i to include the case insensitivity and space, underscore, or character but it won't work.
– John Christopher
Jun 14 at 16:46
I am using it within tableau software. I tried (GreatwWolfwitem*s)/i to include the case insensitivity and space, underscore, or character but it won't work.
– John Christopher
Jun 14 at 16:46
I'm not familiar with this software. What type of Regex does its documentation say it uses? (Abbreviations like ERE or PCRE would be good.)
– roaima
Jun 15 at 8:40
I'm not familiar with this software. What type of Regex does its documentation say it uses? (Abbreviations like ERE or PCRE would be good.)
– roaima
Jun 15 at 8:40
1
1
You talk about replacement in the title, but the question itself does not mention this.
– Kusalananda
Jun 15 at 9:00
You talk about replacement in the title, but the question itself does not mention this.
– Kusalananda
Jun 15 at 9:00
add a comment |Â
3 Answers
3
active
oldest
votes
up vote
0
down vote
One fairly universal expression would be:
/[Gg]reat[_ ][Ww]olf[_ ][Ii]tems/
answered Jun 14 at 17:10
DopeGhoti
39.8k54779
Or/[Gg][Rr][Ee][Aa][Tt][_ ][Ww][Oo][Ll][Ff][_ ][Ii][Tt][Ee][Mm][Ss]/,  to be really case insensitive.
– G-Man
Jun 15 at 5:46
MindGgggreatanditemses
– roaima
Jun 16 at 22:17
@roaima: What?  Oh, I guess I see what you’re saying.  So what? Ggggreat and itemsesis a valid match; the question says “space or underscore between words.â€Â
– G-Man
Jun 17 at 19:33
@G-Man it's the word boundary on the start ofGreator the end ofitemsthat's missing
– roaima
Jun 17 at 19:44
2
IANAL, but my argument is that the question doesn’t really specify that there should be one: it says “returning a string†with “space or underscore between words.â€Â It doesn’t say anything about a word break before the first word or after the last one. (JK; your answer probably is better for what the OP really wants.)    :-)    âÂÂ
– G-Man
Jun 17 at 19:49
add a comment |Â
up vote
0
down vote
Assuming PCRE, the regular expression you've tried cannot match what you're looking for. Let's break it down:
(GreatwWolfwitem*s)/i
- The
wis a marker that says "a character that could belong to a word of text". So it could matchEorpor even6, but not a space. - The
*character means "zero of more of the preceding item", which in this case is the letterm. I'm not entirely sure what you think it should be doing; if you're trying to make thesoptional you need a marker after that character.
If your overall syntax and RE engine is correct, this would match the consecutive words "Great", "Wolf", "Item"/"Items" having one or more spaces between them, in a case insensitive manner:
(bGreats+Wolfs+Items?b)/i
- the
bforces a word boundary (preventing `Ggggreat", for example) - the
s+is "one or more spaces" (+is "one or more of...") - the
s?means that the lettersis optional (?is "zero or one of...")
answered Jun 15 at 8:49
roaima
39.2k544105
add a comment |Â
up vote
0
down vote
If I read the Tableau documentation and the documentation on ICU regular expression referred to in there correctly, you should be able to use
(?i:Great[ _]Wolf[ _]Items)
as the regular expression. The ?i in (?i:RE) turns case sensitivity off for matching the regular expression RE.
answered Jun 15 at 8:57
Kusalananda
101k13199312
add a comment |Â
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
One fairly universal expression would be:
/[Gg]reat[_ ][Ww]olf[_ ][Ii]tems/
answered Jun 14 at 17:10
DopeGhoti
39.8k54779
Or/[Gg][Rr][Ee][Aa][Tt][_ ][Ww][Oo][Ll][Ff][_ ][Ii][Tt][Ee][Mm][Ss]/,  to be really case insensitive.
– G-Man
Jun 15 at 5:46
MindGgggreatanditemses
– roaima
Jun 16 at 22:17
@roaima: What?  Oh, I guess I see what you’re saying.  So what? Ggggreat and itemsesis a valid match; the question says “space or underscore between words.â€Â
– G-Man
Jun 17 at 19:33
@G-Man it's the word boundary on the start ofGreator the end ofitemsthat's missing
– roaima
Jun 17 at 19:44
2
IANAL, but my argument is that the question doesn’t really specify that there should be one: it says “returning a string†with “space or underscore between words.â€Â It doesn’t say anything about a word break before the first word or after the last one. (JK; your answer probably is better for what the OP really wants.)    :-)    âÂÂ
– G-Man
Jun 17 at 19:49
add a comment |Â
up vote
0
down vote
One fairly universal expression would be:
/[Gg]reat[_ ][Ww]olf[_ ][Ii]tems/
answered Jun 14 at 17:10
DopeGhoti
39.8k54779
Or/[Gg][Rr][Ee][Aa][Tt][_ ][Ww][Oo][Ll][Ff][_ ][Ii][Tt][Ee][Mm][Ss]/,  to be really case insensitive.
– G-Man
Jun 15 at 5:46
MindGgggreatanditemses
– roaima
Jun 16 at 22:17
@roaima: What?  Oh, I guess I see what you’re saying.  So what? Ggggreat and itemsesis a valid match; the question says “space or underscore between words.â€Â
– G-Man
Jun 17 at 19:33
@G-Man it's the word boundary on the start ofGreator the end ofitemsthat's missing
– roaima
Jun 17 at 19:44
2
IANAL, but my argument is that the question doesn’t really specify that there should be one: it says “returning a string†with “space or underscore between words.â€Â It doesn’t say anything about a word break before the first word or after the last one. (JK; your answer probably is better for what the OP really wants.)    :-)    âÂÂ
– G-Man
Jun 17 at 19:49
add a comment |Â
up vote
0
down vote
up vote
0
down vote
One fairly universal expression would be:
/[Gg]reat[_ ][Ww]olf[_ ][Ii]tems/
answered Jun 14 at 17:10
DopeGhoti
39.8k54779
One fairly universal expression would be:
/[Gg]reat[_ ][Ww]olf[_ ][Ii]tems/
answered Jun 14 at 17:10
DopeGhoti
39.8k54779
answered Jun 14 at 17:10
DopeGhoti
39.8k54779
answered Jun 14 at 17:10
DopeGhoti
39.8k54779
answered Jun 14 at 17:10
DopeGhoti
39.8k54779
39.8k54779
Or/[Gg][Rr][Ee][Aa][Tt][_ ][Ww][Oo][Ll][Ff][_ ][Ii][Tt][Ee][Mm][Ss]/,  to be really case insensitive.
– G-Man
Jun 15 at 5:46
MindGgggreatanditemses
– roaima
Jun 16 at 22:17
@roaima: What?  Oh, I guess I see what you’re saying.  So what? Ggggreat and itemsesis a valid match; the question says “space or underscore between words.â€Â
– G-Man
Jun 17 at 19:33
@G-Man it's the word boundary on the start ofGreator the end ofitemsthat's missing
– roaima
Jun 17 at 19:44
2
IANAL, but my argument is that the question doesn’t really specify that there should be one: it says “returning a string†with “space or underscore between words.â€Â It doesn’t say anything about a word break before the first word or after the last one. (JK; your answer probably is better for what the OP really wants.)    :-)    âÂÂ
– G-Man
Jun 17 at 19:49
add a comment |Â
Or/[Gg][Rr][Ee][Aa][Tt][_ ][Ww][Oo][Ll][Ff][_ ][Ii][Tt][Ee][Mm][Ss]/,  to be really case insensitive.
– G-Man
Jun 15 at 5:46
MindGgggreatanditemses
– roaima
Jun 16 at 22:17
@roaima: What?  Oh, I guess I see what you’re saying.  So what? Ggggreat and itemsesis a valid match; the question says “space or underscore between words.â€Â
– G-Man
Jun 17 at 19:33
@G-Man it's the word boundary on the start ofGreator the end ofitemsthat's missing
– roaima
Jun 17 at 19:44
2
IANAL, but my argument is that the question doesn’t really specify that there should be one: it says “returning a string†with “space or underscore between words.â€Â It doesn’t say anything about a word break before the first word or after the last one. (JK; your answer probably is better for what the OP really wants.)    :-)    âÂÂ
– G-Man
Jun 17 at 19:49
Or
/[Gg][Rr][Ee][Aa][Tt][_ ][Ww][Oo][Ll][Ff][_ ][Ii][Tt][Ee][Mm][Ss]/,  to be really case insensitive.– G-Man
Jun 15 at 5:46
Or
/[Gg][Rr][Ee][Aa][Tt][_ ][Ww][Oo][Ll][Ff][_ ][Ii][Tt][Ee][Mm][Ss]/,  to be really case insensitive.– G-Man
Jun 15 at 5:46
Mind
Ggggreat and itemses– roaima
Jun 16 at 22:17
Mind
Ggggreat and itemses– roaima
Jun 16 at 22:17
@roaima: What?  Oh, I guess I see what you’re saying.  So what? 
Ggggreat and itemses is a valid match; the question says “space or underscore between words.â€Â– G-Man
Jun 17 at 19:33
@roaima: What?  Oh, I guess I see what you’re saying.  So what? 
Ggggreat and itemses is a valid match; the question says “space or underscore between words.â€Â– G-Man
Jun 17 at 19:33
@G-Man it's the word boundary on the start of
Great or the end of items that's missing– roaima
Jun 17 at 19:44
@G-Man it's the word boundary on the start of
Great or the end of items that's missing– roaima
Jun 17 at 19:44
2
2
IANAL, but my argument is that the question doesn’t really specify that there should be one: it says “returning a string†with “space or underscore between words.â€Â It doesn’t say anything about a word break before the first word or after the last one. (JK; your answer probably is better for what the OP really wants.)    :-)    âÂÂ
– G-Man
Jun 17 at 19:49
IANAL, but my argument is that the question doesn’t really specify that there should be one: it says “returning a string†with “space or underscore between words.â€Â It doesn’t say anything about a word break before the first word or after the last one. (JK; your answer probably is better for what the OP really wants.)    :-)    âÂÂ
– G-Man
Jun 17 at 19:49
add a comment |Â
up vote
0
down vote
Assuming PCRE, the regular expression you've tried cannot match what you're looking for. Let's break it down:
(GreatwWolfwitem*s)/i
- The
wis a marker that says "a character that could belong to a word of text". So it could matchEorpor even6, but not a space. - The
*character means "zero of more of the preceding item", which in this case is the letterm. I'm not entirely sure what you think it should be doing; if you're trying to make thesoptional you need a marker after that character.
If your overall syntax and RE engine is correct, this would match the consecutive words "Great", "Wolf", "Item"/"Items" having one or more spaces between them, in a case insensitive manner:
(bGreats+Wolfs+Items?b)/i
- the
bforces a word boundary (preventing `Ggggreat", for example) - the
s+is "one or more spaces" (+is "one or more of...") - the
s?means that the lettersis optional (?is "zero or one of...")
answered Jun 15 at 8:49
roaima
39.2k544105
add a comment |Â
up vote
0
down vote
Assuming PCRE, the regular expression you've tried cannot match what you're looking for. Let's break it down:
(GreatwWolfwitem*s)/i
- The
wis a marker that says "a character that could belong to a word of text". So it could matchEorpor even6, but not a space. - The
*character means "zero of more of the preceding item", which in this case is the letterm. I'm not entirely sure what you think it should be doing; if you're trying to make thesoptional you need a marker after that character.
If your overall syntax and RE engine is correct, this would match the consecutive words "Great", "Wolf", "Item"/"Items" having one or more spaces between them, in a case insensitive manner:
(bGreats+Wolfs+Items?b)/i
- the
bforces a word boundary (preventing `Ggggreat", for example) - the
s+is "one or more spaces" (+is "one or more of...") - the
s?means that the lettersis optional (?is "zero or one of...")
answered Jun 15 at 8:49
roaima
39.2k544105
add a comment |Â
up vote
0
down vote
up vote
0
down vote
Assuming PCRE, the regular expression you've tried cannot match what you're looking for. Let's break it down:
(GreatwWolfwitem*s)/i
- The
wis a marker that says "a character that could belong to a word of text". So it could matchEorpor even6, but not a space. - The
*character means "zero of more of the preceding item", which in this case is the letterm. I'm not entirely sure what you think it should be doing; if you're trying to make thesoptional you need a marker after that character.
If your overall syntax and RE engine is correct, this would match the consecutive words "Great", "Wolf", "Item"/"Items" having one or more spaces between them, in a case insensitive manner:
(bGreats+Wolfs+Items?b)/i
- the
bforces a word boundary (preventing `Ggggreat", for example) - the
s+is "one or more spaces" (+is "one or more of...") - the
s?means that the lettersis optional (?is "zero or one of...")
answered Jun 15 at 8:49
roaima
39.2k544105
Assuming PCRE, the regular expression you've tried cannot match what you're looking for. Let's break it down:
(GreatwWolfwitem*s)/i
- The
wis a marker that says "a character that could belong to a word of text". So it could matchEorpor even6, but not a space. - The
*character means "zero of more of the preceding item", which in this case is the letterm. I'm not entirely sure what you think it should be doing; if you're trying to make thesoptional you need a marker after that character.
If your overall syntax and RE engine is correct, this would match the consecutive words "Great", "Wolf", "Item"/"Items" having one or more spaces between them, in a case insensitive manner:
(bGreats+Wolfs+Items?b)/i
- the
bforces a word boundary (preventing `Ggggreat", for example) - the
s+is "one or more spaces" (+is "one or more of...") - the
s?means that the lettersis optional (?is "zero or one of...")
answered Jun 15 at 8:49
roaima
39.2k544105
answered Jun 15 at 8:49
roaima
39.2k544105
answered Jun 15 at 8:49
roaima
39.2k544105
answered Jun 15 at 8:49
roaima
39.2k544105
39.2k544105
add a comment |Â
add a comment |Â
up vote
0
down vote
If I read the Tableau documentation and the documentation on ICU regular expression referred to in there correctly, you should be able to use
(?i:Great[ _]Wolf[ _]Items)
as the regular expression. The ?i in (?i:RE) turns case sensitivity off for matching the regular expression RE.
answered Jun 15 at 8:57
Kusalananda
101k13199312
add a comment |Â
up vote
0
down vote
If I read the Tableau documentation and the documentation on ICU regular expression referred to in there correctly, you should be able to use
(?i:Great[ _]Wolf[ _]Items)
as the regular expression. The ?i in (?i:RE) turns case sensitivity off for matching the regular expression RE.
answered Jun 15 at 8:57
Kusalananda
101k13199312
add a comment |Â
up vote
0
down vote
up vote
0
down vote
If I read the Tableau documentation and the documentation on ICU regular expression referred to in there correctly, you should be able to use
(?i:Great[ _]Wolf[ _]Items)
as the regular expression. The ?i in (?i:RE) turns case sensitivity off for matching the regular expression RE.
answered Jun 15 at 8:57
Kusalananda
101k13199312
If I read the Tableau documentation and the documentation on ICU regular expression referred to in there correctly, you should be able to use
(?i:Great[ _]Wolf[ _]Items)
as the regular expression. The ?i in (?i:RE) turns case sensitivity off for matching the regular expression RE.
answered Jun 15 at 8:57
Kusalananda
101k13199312
answered Jun 15 at 8:57
Kusalananda
101k13199312
answered Jun 15 at 8:57
Kusalananda
101k13199312
answered Jun 15 at 8:57
Kusalananda
101k13199312
101k13199312
add a comment |Â
add a comment |Â
Â
draft saved
draft discarded
Â
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f449849%2fnew-to-regex-and-using-it-for-a-project-need-help-with-a-regexp-replace-stateme%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
1
What regex engine / flavor are you using, and what have you tried?
– steeldriver
Jun 14 at 16:32
I am using it within tableau software. I tried (GreatwWolfwitem*s)/i to include the case insensitivity and space, underscore, or character but it won't work.
– John Christopher
Jun 14 at 16:46
I'm not familiar with this software. What type of Regex does its documentation say it uses? (Abbreviations like ERE or PCRE would be good.)
– roaima
Jun 15 at 8:40
1
You talk about replacement in the title, but the question itself does not mention this.
– Kusalananda
Jun 15 at 9:00