how to match all punctuation character in VBA regex (such as 'p{P}' in some other language)











up vote
0
down vote

favorite












I want to match all punctuation character



I know can use 'p{P}' in PHP or other languages



but, it seems not works in VBA.
I try to use
pattern = "[.,x0ax21x22x24x26x27x28x29x2ax2d
x3bx3cx3ex3fx5b2x5dx5ex60x7bx7cx7dx7e]"



but I think this not a good way, Can someone give me some advice? Thank you










share|improve this question
























  • Word and Excel have different "Find" functionality if you mean to search document content. So you shouldn't ask one question for the two different application interfaces. Then I recommend you research using "Find" within each application, starting with the options available in the dialog box. I don't know about Excel, but Word has extended functionality that can search specific character codes; it also has "wildcards" which is as close to RegEx as you can get in the Word interface.
    – Cindy Meister
    Nov 9 at 11:13










  • What does not working mean?
    – QHarr
    Nov 9 at 11:28












  • @CindyMeister Now the problem is that I want to match any punctuation mark, and if I use wildcards (such as [,.:;{}()]. ), I always feel that some of punctuation mark will be missed. may be this Punctuation ! in document, then I can't find it
    – Ke R.P.
    Nov 10 at 15:51












  • Word has no way of specifying "any/all punctuation". You have to know what punctuation to inlcude... But the RegEx you show us is no different - that just lists character codes instead of literal characters.
    – Cindy Meister
    Nov 10 at 19:07















up vote
0
down vote

favorite












I want to match all punctuation character



I know can use 'p{P}' in PHP or other languages



but, it seems not works in VBA.
I try to use
pattern = "[.,x0ax21x22x24x26x27x28x29x2ax2d
x3bx3cx3ex3fx5b2x5dx5ex60x7bx7cx7dx7e]"



but I think this not a good way, Can someone give me some advice? Thank you










share|improve this question
























  • Word and Excel have different "Find" functionality if you mean to search document content. So you shouldn't ask one question for the two different application interfaces. Then I recommend you research using "Find" within each application, starting with the options available in the dialog box. I don't know about Excel, but Word has extended functionality that can search specific character codes; it also has "wildcards" which is as close to RegEx as you can get in the Word interface.
    – Cindy Meister
    Nov 9 at 11:13










  • What does not working mean?
    – QHarr
    Nov 9 at 11:28












  • @CindyMeister Now the problem is that I want to match any punctuation mark, and if I use wildcards (such as [,.:;{}()]. ), I always feel that some of punctuation mark will be missed. may be this Punctuation ! in document, then I can't find it
    – Ke R.P.
    Nov 10 at 15:51












  • Word has no way of specifying "any/all punctuation". You have to know what punctuation to inlcude... But the RegEx you show us is no different - that just lists character codes instead of literal characters.
    – Cindy Meister
    Nov 10 at 19:07













up vote
0
down vote

favorite









up vote
0
down vote

favorite











I want to match all punctuation character



I know can use 'p{P}' in PHP or other languages



but, it seems not works in VBA.
I try to use
pattern = "[.,x0ax21x22x24x26x27x28x29x2ax2d
x3bx3cx3ex3fx5b2x5dx5ex60x7bx7cx7dx7e]"



but I think this not a good way, Can someone give me some advice? Thank you










share|improve this question















I want to match all punctuation character



I know can use 'p{P}' in PHP or other languages



but, it seems not works in VBA.
I try to use
pattern = "[.,x0ax21x22x24x26x27x28x29x2ax2d
x3bx3cx3ex3fx5b2x5dx5ex60x7bx7cx7dx7e]"



but I think this not a good way, Can someone give me some advice? Thank you







excel vba ms-word






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 9 at 11:11









Cindy Meister

13.7k102034




13.7k102034










asked Nov 9 at 10:50









Ke R.P.

23




23












  • Word and Excel have different "Find" functionality if you mean to search document content. So you shouldn't ask one question for the two different application interfaces. Then I recommend you research using "Find" within each application, starting with the options available in the dialog box. I don't know about Excel, but Word has extended functionality that can search specific character codes; it also has "wildcards" which is as close to RegEx as you can get in the Word interface.
    – Cindy Meister
    Nov 9 at 11:13










  • What does not working mean?
    – QHarr
    Nov 9 at 11:28












  • @CindyMeister Now the problem is that I want to match any punctuation mark, and if I use wildcards (such as [,.:;{}()]. ), I always feel that some of punctuation mark will be missed. may be this Punctuation ! in document, then I can't find it
    – Ke R.P.
    Nov 10 at 15:51












  • Word has no way of specifying "any/all punctuation". You have to know what punctuation to inlcude... But the RegEx you show us is no different - that just lists character codes instead of literal characters.
    – Cindy Meister
    Nov 10 at 19:07


















  • Word and Excel have different "Find" functionality if you mean to search document content. So you shouldn't ask one question for the two different application interfaces. Then I recommend you research using "Find" within each application, starting with the options available in the dialog box. I don't know about Excel, but Word has extended functionality that can search specific character codes; it also has "wildcards" which is as close to RegEx as you can get in the Word interface.
    – Cindy Meister
    Nov 9 at 11:13










  • What does not working mean?
    – QHarr
    Nov 9 at 11:28












  • @CindyMeister Now the problem is that I want to match any punctuation mark, and if I use wildcards (such as [,.:;{}()]. ), I always feel that some of punctuation mark will be missed. may be this Punctuation ! in document, then I can't find it
    – Ke R.P.
    Nov 10 at 15:51












  • Word has no way of specifying "any/all punctuation". You have to know what punctuation to inlcude... But the RegEx you show us is no different - that just lists character codes instead of literal characters.
    – Cindy Meister
    Nov 10 at 19:07
















Word and Excel have different "Find" functionality if you mean to search document content. So you shouldn't ask one question for the two different application interfaces. Then I recommend you research using "Find" within each application, starting with the options available in the dialog box. I don't know about Excel, but Word has extended functionality that can search specific character codes; it also has "wildcards" which is as close to RegEx as you can get in the Word interface.
– Cindy Meister
Nov 9 at 11:13




Word and Excel have different "Find" functionality if you mean to search document content. So you shouldn't ask one question for the two different application interfaces. Then I recommend you research using "Find" within each application, starting with the options available in the dialog box. I don't know about Excel, but Word has extended functionality that can search specific character codes; it also has "wildcards" which is as close to RegEx as you can get in the Word interface.
– Cindy Meister
Nov 9 at 11:13












What does not working mean?
– QHarr
Nov 9 at 11:28






What does not working mean?
– QHarr
Nov 9 at 11:28














@CindyMeister Now the problem is that I want to match any punctuation mark, and if I use wildcards (such as [,.:;{}()]. ), I always feel that some of punctuation mark will be missed. may be this Punctuation ! in document, then I can't find it
– Ke R.P.
Nov 10 at 15:51






@CindyMeister Now the problem is that I want to match any punctuation mark, and if I use wildcards (such as [,.:;{}()]. ), I always feel that some of punctuation mark will be missed. may be this Punctuation ! in document, then I can't find it
– Ke R.P.
Nov 10 at 15:51














Word has no way of specifying "any/all punctuation". You have to know what punctuation to inlcude... But the RegEx you show us is no different - that just lists character codes instead of literal characters.
– Cindy Meister
Nov 10 at 19:07




Word has no way of specifying "any/all punctuation". You have to know what punctuation to inlcude... But the RegEx you show us is no different - that just lists character codes instead of literal characters.
– Cindy Meister
Nov 10 at 19:07

















active

oldest

votes











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',
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
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53224279%2fhow-to-match-all-punctuation-character-in-vba-regex-such-as-pp-in-some-oth%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown






























active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes
















draft saved

draft discarded




















































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.





Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


Please pay close attention to the following guidance:


  • 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.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53224279%2fhow-to-match-all-punctuation-character-in-vba-regex-such-as-pp-in-some-oth%23new-answer', 'question_page');
}
);

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







這個網誌中的熱門文章

Xamarin.form Move up view when keyboard appear

Post-Redirect-Get with Spring WebFlux and Thymeleaf

Anylogic : not able to use stopDelay()