tag:blogger.com,1999:blog-5081137459980209833.post4741866389613490557..comments2023-06-07T04:37:56.671-04:00Comments on Ben Mearns: wildcard regex in notepadAnonymoushttp://www.blogger.com/profile/16203487152727179441noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5081137459980209833.post-84836963718053118722011-03-17T09:49:17.862-04:002011-03-17T09:49:17.862-04:00for example, to search for
CHAR(3) in the subjec...for example, to search for <br /><br />CHAR(3) in the subject CREATE TABLE ENTITY_ACAD_BLDG_TRANS ( ACAD_CODE CHAR(3) NOT NULL, BLDG_CODE CHAR(4), LOCATION VARCHAR2(64) NOT NULL, CONSTRAINT ENTITY_ACAD_BLDG_TRANS_PK PRIMARY KEY (ACAD_CODE) );<br /><br />use this:<br />CHAR([^)]+)[)]Anonymoushttps://www.blogger.com/profile/16203487152727179441noreply@blogger.comtag:blogger.com,1999:blog-5081137459980209833.post-7449895770554553732011-03-17T09:48:27.448-04:002011-03-17T09:48:27.448-04:00this is a problem though, when the delimiting char...this is a problem though, when the delimiting characters appear more than once in the subject you are searching ... notepad++ doesn't support a non-greedy search ... instead specific what character you AREN'T searching for <br /><br />as in:<br />http://stackoverflow.com/questions/3971052/notepad-non-greedy-regular-expressionsAnonymoushttps://www.blogger.com/profile/16203487152727179441noreply@blogger.com