{"id":6536,"date":"2017-11-20T11:14:07","date_gmt":"2017-11-20T02:14:07","guid":{"rendered":"http:\/\/excelwork.info\/excel\/?p=6536"},"modified":"2018-03-24T22:51:31","modified_gmt":"2018-03-24T13:51:31","slug":"vbaregexp","status":"publish","type":"post","link":"https:\/\/excelwork.info\/excel\/vbaregexp\/","title":{"rendered":"VBA \u3067\u6b63\u898f\u8868\u73fe\u3092\u4f7f\u3046\uff08RegExp \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\uff09"},"content":{"rendered":"

RegExp \u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/h2>\n
\n

VBA \u3067\u6b63\u898f\u8868\u73fe\u3092\u4f7f\u3046\u306b\u306f\u3001VBScript \u306eRegExp \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002
\n RegExp \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4f7f\u3046\u306b\u306f\u3001CreateObject \u95a2\u6570<\/strong>\u3092\u5229\u7528\u3059\u308b\u304b\u3001\u53c2\u7167\u8a2d\u5b9a\u3067\u300cMicrosoft VBScript Regular Expressions 5.5<\/strong>\u300d\u306b\u30c1\u30a7\u30c3\u30af\u3092\u4ed8\u3051\u307e\u3059\u3002\u53c2\u7167\u8a2d\u5b9a\u306e\u65b9\u6cd5\u306b\u3064\u3044\u3066\u306f\u3001\u30d5\u30a1\u30a4\u30eb\u30b7\u30b9\u30c6\u30e0\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\uff08FileSystemObject\uff09<\/a>\u306e\u4f7f\u3044\u65b9 \u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\n

\u3010\u66f8\u5f0f\u3011<\/strong><\/p>\n

\uff1c\u53c2\u7167\u8a2d\u5b9a\uff1e<\/strong><\/span>
\n Dim<\/b> re<\/em> As RegExp<\/b>
\n Set<\/b> re<\/em> = New RegExp<\/b><\/p>\n

\uff1cCreateObject \u95a2\u6570\u3092\u4f7f\u7528\uff1e<\/strong><\/span>
\n Dim<\/b> re<\/em> As Object<\/b>
\n Set<\/b> re<\/em> = CreateObject(“VBScript.RegExp”)<\/b><\/p><\/div>\n
\n

\n

RegExp \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3001\u30e1\u30bd\u30c3\u30c9\u306e\u8a73\u7d30\u3001\u4f7f\u7528\u4f8b\u306b\u95a2\u3057\u3066\u306f\u3001
\n VBA \u3067\u6b63\u898f\u8868\u73fe\u3092\u4f7f\u3046\uff08RegExp \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\uff09<\/a>
\n VBA \u3067\u6b63\u898f\u8868\u73fe\u3092\u4f7f\u3046\uff08RegExp \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30e1\u30bd\u30c3\u30c9\uff09<\/a>
\n \u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
<\/div>\n<\/div>\n

\n

RegExp \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30d1\u30bf\u30fc\u30f3\u6587\u5b57\u5217\u3068\u3057\u3066\u4f7f\u7528\u3067\u304d\u308b\u30e1\u30bf\u6587\u5b57<\/h2>\n
\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\u30b7\u30f3\u30dc\u30eb<\/strong><\/td>\n\u6a5f\u80fd<\/strong><\/td>\n<\/tr>\n
\u4f4d\u7f6e\u30de\u30c3\u30c1\u30f3\u30b0<\/strong> \u2026 \u6587\u5b57\u306e\u59cb\u307e\u308a\u3084\u7d42\u308f\u308a\u3092\u691c\u7d22\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
^<\/td>\n\u6587\u5b57\u5217\u306e\u5148\u982d\u306b\u306e\u307f\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
$<\/td>\n\u6587\u5b57\u5217\u306e\u672b\u5c3e\u306b\u306e\u307f\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\b<\/td>\n\u4efb\u610f\u306e\u5358\u8a9e\u306e\u5883\u754c\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\B<\/td>\n\u5358\u8a9e\u306e\u5883\u754c\u4ee5\u5916\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\u30ea\u30c6\u30e9\u30eb\u306e\u691c\u7d22<\/strong> \u2026 \u6587\u5b57\u306e\u524d\u306b \u201c\\\u201d \u3092\u7f6e\u304d\u307e\u3059\u3002<\/td>\n<\/tr>\n
\u82f1\u6570\u5b57<\/td>\n\u82f1\u5b57\u3068\u6570\u5b57\u306b\u6587\u5b57\u3069\u304a\u308a\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\n<\/td>\n\u6539\u884c\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\f<\/td>\n\u30d5\u30a9\u30fc\u30e0 \u30d5\u30a3\u30fc\u30c9\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\r<\/td>\n\u30ad\u30e3\u30ea\u30c3\u30b8 \u30ea\u30bf\u30fc\u30f3\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\t<\/td>\n\u6c34\u5e73\u30bf\u30d6\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\v<\/td>\n\u5782\u76f4\u30bf\u30d6\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\?<\/td>\n? \u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\*<\/td>\n* \u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\+<\/td>\n+ \u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\.<\/td>\n. \u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\|<\/td>\n| \u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\{<\/td>\n{ \u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\}<\/td>\n} \u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\\\<\/td>\n\\ \u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\[<\/td>\n[ \u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\]<\/td>\n] \u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\(<\/td>\n( \u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\)<\/td>\n) \u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\xxx<\/td>\n8\u9032\u6570 xxx \u306b\u3088\u3063\u3066\u8868\u73fe\u3055\u308c\u308bASCII\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\xdd<\/td>\n16\u9032\u6570 dd \u306b\u3088\u3063\u3066\u8868\u73fe\u3055\u308c\u308bASCII\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\uxxxx<\/td>\nUNICODE xxxx \u306b\u3088\u3063\u3066\u8868\u73fe\u3055\u308c\u308bASCII\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\u6587\u5b57\u30af\u30e9\u30b9<\/strong><\/td>\n<\/tr>\n
[]<\/td>\n[] \u5185\u306b\u542b\u307e\u308c\u3066\u3044\u308b\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
[^]<\/td>\n[^] \u306b\u542b\u307e\u308c\u3066\u3044\u306a\u3044\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
.<\/td>\n\\n \u4ee5\u5916\u306e\u4efb\u610f\u306e\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\\w<\/td>\n\u5358\u8a9e\u306b\u4f7f\u7528\u3055\u308c\u308b\u4efb\u610f\u306e\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002[a-zA-Z_0-9]\u3068\u7b49\u4fa1\u3002<\/td>\n<\/tr>\n
\\W<\/td>\n\u5358\u8a9e\u306b\u4f7f\u7528\u3055\u308c\u308b\u6587\u5b57\u4ee5\u5916\u306e\u4efb\u610f\u306e\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002[^a-zA-Z_0-9]\u3068\u7b49\u4fa1\u3002<\/td>\n<\/tr>\n
\\d<\/td>\n\u4efb\u610f\u306e\u6570\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002[0-9]\u3068\u7b49\u4fa1\u3002<\/td>\n<\/tr>\n
\\D<\/td>\n\u4efb\u610f\u306e\u6570\u5b57\u4ee5\u5916\u306e\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002[^0-9]\u3068\u7b49\u4fa1\u3002<\/td>\n<\/tr>\n
\\s<\/td>\n\u4efb\u610f\u306e\u30b9\u30da\u30fc\u30b9\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002[ \\t\\r\\n\\v\\f]\u3068\u7b49\u4fa1\u3002<\/td>\n<\/tr>\n
\\S<\/td>\n\u4efb\u610f\u306e\u975e\u30b9\u30da\u30fc\u30b9\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002[^ \\t\\r\\n\\v\\f]\u3068\u7b49\u4fa1\u3002<\/td>\n<\/tr>\n
\u7e70\u308a\u8fd4\u3057<\/strong><\/td>\n<\/tr>\n
{n}<\/td>\n\u6b63\u898f\u8868\u73fe\u306e\u3061\u3087\u3046\u3069 n\u500b\u306e\u76f4\u524d\u306e\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
{n,}<\/td>\n\u6b63\u898f\u8868\u73fe\u306en\u500b\u4ee5\u4e0a\u306e\u76f4\u524d\u306e\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
{n1,n2}<\/td>\n\u6b63\u898f\u8868\u73fe\u306en1\u500b\u4ee5\u4e0a\u3001n2\u500b\u4ee5\u4e0b\u306e\u76f4\u524d\u306e\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
?<\/td>\n\u30bc\u30ed\u500b\u307e\u305f\u306f1\u500b\u306e\u76f4\u524d\u306e\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002{0,1}\u3068\u7b49\u4fa1\u3002<\/td>\n<\/tr>\n
*<\/td>\n\u30bc\u30ed\u500b\u4ee5\u4e0a\u306e\u76f4\u524d\u306e\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002{0,}\u3068\u7b49\u4fa1\u3002<\/td>\n<\/tr>\n
+<\/td>\n1\u500b\u4ee5\u4e0a\u306e\u76f4\u524d\u306e\u6587\u5b57\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002{1,}\u3068\u7b49\u4fa1\u3002<\/td>\n<\/tr>\n
\u9078\u629e\u3068\u30b0\u30eb\u30fc\u30d7\u5316<\/strong><\/td>\n<\/tr>\n
()<\/td>\n\u8907\u6570\u306e\u53e5\u3092\u30b0\u30eb\u30fc\u30d7\u5316\u3057\u3066\u30011\u3064\u306e\u53e5\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u30cd\u30b9\u30c8\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/td>\n<\/tr>\n
|<\/td>\n\u9078\u629e\u306f\u3001\u8907\u6570\u306e\u53e5\u30921\u3064\u306e\u6b63\u898f\u8868\u73fe\u306b\u307e\u3068\u3081\u3001\u3053\u308c\u3089\u306e\u3046\u3061\u306e\u4efb\u610f\u306e\u53e5\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n
\u5f8c\u65b9\u53c2\u7167<\/strong><\/td>\n<\/tr>\n
()\\n<\/td>\nn\u756a\u76ee\u306e\u62ec\u5f27\u3067\u56f2\u307e\u308c\u305f\u53e5\u306b\u30de\u30c3\u30c1\u3057\u307e\u3059\u3002<\/td>\n<\/tr>\n<\/table>\n

<\/p>\n<\/div>\n

\n

VBA\u3067\u6b63\u898f\u8868\u73fe\u3092\u4f7f\u7528\u3059\u308b\u4f8b<\/h2>\n
\n

\u30b5\u30f3\u30d7\u30ebVBA\u30bd\u30fc\u30b9<\/h3>\n
\r\n\u3000\r\nSub Sample_RegExp()\r\n    \r\n    Dim re As RegExp\r\n    Dim i As Long\r\n    Dim mystr As String\r\n    Dim str(1 To 5) As String\r\n    \r\n    Set re = New RegExp\r\n    \r\n    str(1) = \"12345abcd\"\r\n    str(2) = \"\u3042\u3044\u3046\u3048\u304a\u304b\u304d\u304f\"\r\n    str(3) = \"123456XYZ\"\r\n    str(4) = \"00865eerrU\"\r\n    str(5) = \"id_password\"\r\n    \r\n    re.Pattern = \"^[a-z0-9_]+$\"\r\n    \r\n    For i = 1 To 5\r\n        mystr = mystr & vbCrLf & _\r\n                str(i) & vbTab & re.Test(str(i))\r\n    Next i\r\n    \r\n    MsgBox mystr\r\n    \r\nEnd Sub\r\n\u3000\r\n  <\/pre>\n
\n
\u5b9f\u884c\u7d50\u679c<\/h3>\n
\"VBA\u6b63\u898f\u8868\u73fe\u4f7f\u7528\u4f8b\"<\/a><\/p>\n<\/div>\n

\n","protected":false},"excerpt":{"rendered":"
RegExp \u30aa\u30d6\u30b8\u30a7\u30af\u30c8 VBA \u3067\u6b63\u898f\u8868\u73fe\u3092\u4f7f\u3046\u306b\u306f\u3001VBScript \u306eR … <\/p>\n","protected":false},"author":1,"featured_media":6545,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"amp_status":"","spay_email":"","jetpack_publicize_message":""},"categories":[37],"tags":[954,1049,63,1048,955,1047],"jetpack_featured_media_url":"https:\/\/i2.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2017\/11\/vbaregexp.jpg?fit=189%2C223&ssl=1","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4Ye9i-1Hq","_links":{"self":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/6536"}],"collection":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/comments?post=6536"}],"version-history":[{"count":23,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/6536\/revisions"}],"predecessor-version":[{"id":6637,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/6536\/revisions\/6637"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/media\/6545"}],"wp:attachment":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/media?parent=6536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/categories?post=6536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/tags?post=6536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}