Regular Expression - Get String between 2 Strings
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I am facing issues extracting a string between two strings/pattern.
This is what I got so far:
https://regex101.com/r/yuoQha/1
The problem I have is that I receive a way too long string with the RegEx code I have designed, because it seems that RegEx searches from backwards on?
I marked in red what I only need.
How should I modify my RegEx pattern? Does Lookahead/Lookbehind have something to do with the solution?
At the end it should work with VBA. Any help is highly appreciated.
regex excel vba
asked Nov 17 '18 at 1:54
smartinismartini
1087
add a comment |
I am facing issues extracting a string between two strings/pattern.
This is what I got so far:
https://regex101.com/r/yuoQha/1
The problem I have is that I receive a way too long string with the RegEx code I have designed, because it seems that RegEx searches from backwards on?
I marked in red what I only need.
How should I modify my RegEx pattern? Does Lookahead/Lookbehind have something to do with the solution?
At the end it should work with VBA. Any help is highly appreciated.
regex excel vba
asked Nov 17 '18 at 1:54
smartinismartini
1087
stackoverflow.com/a/1732454/62576
– Ken White
Nov 17 '18 at 2:08
add a comment |
I am facing issues extracting a string between two strings/pattern.
This is what I got so far:
https://regex101.com/r/yuoQha/1
The problem I have is that I receive a way too long string with the RegEx code I have designed, because it seems that RegEx searches from backwards on?
I marked in red what I only need.
How should I modify my RegEx pattern? Does Lookahead/Lookbehind have something to do with the solution?
At the end it should work with VBA. Any help is highly appreciated.
regex excel vba
asked Nov 17 '18 at 1:54
smartinismartini
1087
I am facing issues extracting a string between two strings/pattern.
This is what I got so far:
https://regex101.com/r/yuoQha/1
The problem I have is that I receive a way too long string with the RegEx code I have designed, because it seems that RegEx searches from backwards on?
I marked in red what I only need.
How should I modify my RegEx pattern? Does Lookahead/Lookbehind have something to do with the solution?
At the end it should work with VBA. Any help is highly appreciated.
regex excel vba
regex excel vba
asked Nov 17 '18 at 1:54
smartinismartini
1087
asked Nov 17 '18 at 1:54
smartinismartini
1087
asked Nov 17 '18 at 1:54
smartinismartini
1087
asked Nov 17 '18 at 1:54
smartinismartini
1087
asked Nov 17 '18 at 1:54
smartinismartini
1087
1087
stackoverflow.com/a/1732454/62576
– Ken White
Nov 17 '18 at 2:08
add a comment |
stackoverflow.com/a/1732454/62576
– Ken White
Nov 17 '18 at 2:08
stackoverflow.com/a/1732454/62576
– Ken White
Nov 17 '18 at 2:08
stackoverflow.com/a/1732454/62576
– Ken White
Nov 17 '18 at 2:08
add a comment |
1 Answer
1
active
oldest
votes
Try this pattern:
OEM]]><[/]Name><Value>(.*?NameValueList.*?)(?=<[/]Value><[/]NameValueList)
It matches exactly what is orange in your image.
FYI, the ? after the .* are to make it non-greedy. Needed to add NameValue in there since you want it to appear once in your pattern.
answered Nov 17 '18 at 2:08
cybernetic.nomadcybernetic.nomad
3,02121222
worked for me, thanks. still try to understand that logic though. why was there a down vote actually, if there are solutions to questions? did I miss something?
– smartini
Nov 17 '18 at 2:19
2
blogs.msdn.microsoft.com/ericgu/2005/08/19/…
– CatCat
Nov 17 '18 at 3:56
thanks for that link, well explained.
– smartini
Nov 17 '18 at 10:22
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53347504%2fregular-expression-get-string-between-2-strings%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try this pattern:
OEM]]><[/]Name><Value>(.*?NameValueList.*?)(?=<[/]Value><[/]NameValueList)
It matches exactly what is orange in your image.
FYI, the ? after the .* are to make it non-greedy. Needed to add NameValue in there since you want it to appear once in your pattern.
answered Nov 17 '18 at 2:08
cybernetic.nomadcybernetic.nomad
3,02121222
worked for me, thanks. still try to understand that logic though. why was there a down vote actually, if there are solutions to questions? did I miss something?
– smartini
Nov 17 '18 at 2:19
2
blogs.msdn.microsoft.com/ericgu/2005/08/19/…
– CatCat
Nov 17 '18 at 3:56
thanks for that link, well explained.
– smartini
Nov 17 '18 at 10:22
add a comment |
Try this pattern:
OEM]]><[/]Name><Value>(.*?NameValueList.*?)(?=<[/]Value><[/]NameValueList)
It matches exactly what is orange in your image.
FYI, the ? after the .* are to make it non-greedy. Needed to add NameValue in there since you want it to appear once in your pattern.
answered Nov 17 '18 at 2:08
cybernetic.nomadcybernetic.nomad
3,02121222
worked for me, thanks. still try to understand that logic though. why was there a down vote actually, if there are solutions to questions? did I miss something?
– smartini
Nov 17 '18 at 2:19
2
blogs.msdn.microsoft.com/ericgu/2005/08/19/…
– CatCat
Nov 17 '18 at 3:56
thanks for that link, well explained.
– smartini
Nov 17 '18 at 10:22
add a comment |
Try this pattern:
OEM]]><[/]Name><Value>(.*?NameValueList.*?)(?=<[/]Value><[/]NameValueList)
It matches exactly what is orange in your image.
FYI, the ? after the .* are to make it non-greedy. Needed to add NameValue in there since you want it to appear once in your pattern.
answered Nov 17 '18 at 2:08
cybernetic.nomadcybernetic.nomad
3,02121222
Try this pattern:
OEM]]><[/]Name><Value>(.*?NameValueList.*?)(?=<[/]Value><[/]NameValueList)
It matches exactly what is orange in your image.
FYI, the ? after the .* are to make it non-greedy. Needed to add NameValue in there since you want it to appear once in your pattern.
answered Nov 17 '18 at 2:08
cybernetic.nomadcybernetic.nomad
3,02121222
answered Nov 17 '18 at 2:08
cybernetic.nomadcybernetic.nomad
3,02121222
answered Nov 17 '18 at 2:08
cybernetic.nomadcybernetic.nomad
3,02121222
answered Nov 17 '18 at 2:08
cybernetic.nomadcybernetic.nomad
3,02121222
3,02121222
worked for me, thanks. still try to understand that logic though. why was there a down vote actually, if there are solutions to questions? did I miss something?
– smartini
Nov 17 '18 at 2:19
2
blogs.msdn.microsoft.com/ericgu/2005/08/19/…
– CatCat
Nov 17 '18 at 3:56
thanks for that link, well explained.
– smartini
Nov 17 '18 at 10:22
add a comment |
worked for me, thanks. still try to understand that logic though. why was there a down vote actually, if there are solutions to questions? did I miss something?
– smartini
Nov 17 '18 at 2:19
2
blogs.msdn.microsoft.com/ericgu/2005/08/19/…
– CatCat
Nov 17 '18 at 3:56
thanks for that link, well explained.
– smartini
Nov 17 '18 at 10:22
worked for me, thanks. still try to understand that logic though. why was there a down vote actually, if there are solutions to questions? did I miss something?
– smartini
Nov 17 '18 at 2:19
worked for me, thanks. still try to understand that logic though. why was there a down vote actually, if there are solutions to questions? did I miss something?
– smartini
Nov 17 '18 at 2:19
2
2
blogs.msdn.microsoft.com/ericgu/2005/08/19/…
– CatCat
Nov 17 '18 at 3:56
blogs.msdn.microsoft.com/ericgu/2005/08/19/…
– CatCat
Nov 17 '18 at 3:56
thanks for that link, well explained.
– smartini
Nov 17 '18 at 10:22
thanks for that link, well explained.
– smartini
Nov 17 '18 at 10:22
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53347504%2fregular-expression-get-string-between-2-strings%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
stackoverflow.com/a/1732454/62576
– Ken White
Nov 17 '18 at 2:08