tag:blogger.com,1999:blog-61450753817954324982024-03-14T02:40:26.357+00:00CodeWiz TipsIT Consultants tips and tricksCodeWizhttp://www.blogger.com/profile/11013250283932483732noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6145075381795432498.post-9398494847298004052011-04-04T11:44:00.000+01:002011-04-04T11:44:20.702+01:00Regex 101 - Introduction<div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: left;"><b><span lang="PT" style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">Predefined Character Classes</span></b></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: left;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: left;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">. </span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">Any character (may or may not match line terminators) </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">\d</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> A digit: </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">[0-9]</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">\D</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> A non-digit: </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">[^0-9]</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">\s</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> A whitespace character: </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">[ \t\n\x0B\f\r]</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">\S</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> A non-whitespace character: </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">[^\s]</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">\w</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> A word character: </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">[a-zA-Z_0-9]</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">\W</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> A non-word character: </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">[^\w]</span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: left;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"><b>Quantifiers</b></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt; text-align: left;"><b><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">Meaning</span></b><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> <b>Greedy</b> <b>Reluctant</b> <b>Possessive</b> </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X?</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X??</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X?+</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><i><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X</span></i><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">, once or not at all </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X*</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X*?</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X*+</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><i><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X</span></i><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">, zero or more times </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X+</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X+?</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X++</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><i><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X</span></i><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">, one or more times </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X{n} </span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X{n}? </span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X{n}+ </span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><i><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X</span></i><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">, exactly </span><i><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">n</span></i><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> times </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X{n,}</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X{n,}?</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X{n,}+</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><i><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X</span></i><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">, at least </span><i><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">n</span></i><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> times </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X{n,m}</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X{n,m}?</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X{n,m}+</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><i><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">X</span></i><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">, at least </span><i><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">n</span></i><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> but not more than </span><i><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">m</span></i><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> times</span><span style="mso-ansi-language: EN-US;"></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;"></span></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: left;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: left;"><b><span lang="PT" style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">Boundary Matchers</span></b><span lang="PT" style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> </span><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">^</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> The beginning of a line </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">$</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> The end of a line </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">\b</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> A word boundary </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">\B</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> A non-word boundary </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">\A</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> The beginning of the input </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">\G</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> The end of the previous match </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">\Z</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> The end of the input but for the final terminator, if any </span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="font-family: "Courier New"; font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">\z</span><span style="font-family: "Times New Roman", "serif"; font-size: 12pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"> The end of the input</span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><br />
</div><span style="mso-ansi-language: EN-US;"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: left;"><b><span lang="PT" style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;">Constant Equivalent Embedded Flag Expression</span></b></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: left;"><b><span lang="PT" style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: PT;"></span></b></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><code><span style="font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">Pattern.CANON_EQ</span></code><span style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;"> None </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><code><span style="font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">Pattern.CASE_INSENSITIVE</span></code><span style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;"> </span></span><code><span style="font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">(?i)</span></code><span style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><code><span style="font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">Pattern.COMMENTS</span></code><span style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;"> </span></span><code><span style="font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">(?x)</span></code><span style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><code><span style="font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">Pattern.MULTILINE </span></code><span style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;"> </span></span><code><span style="font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">(?m)</span></code><span style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><code><span style="font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">Pattern.DOTALL</span></code><span style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;"> </span></span><code><span style="font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">(?s)</span></code><span style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><code><span style="font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">Pattern.LITERAL</span></code><span style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;"> None </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><code><span style="font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">Pattern.UNICODE_CASE</span></code><span style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;"> </span></span><code><span style="font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">(?u)</span></code><span style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;"> </span></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><code><span style="font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">Pattern.UNIX_LINES</span></code><span style="mso-ansi-language: EN-US;"><span style="font-family: Calibri;"> </span></span><code><span style="font-size: 10pt; line-height: 115%; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">(?d)</span></code></div></span>CodeWizhttp://www.blogger.com/profile/11013250283932483732noreply@blogger.com0tag:blogger.com,1999:blog-6145075381795432498.post-5828953433638464182011-04-01T16:28:00.001+01:002011-04-01T16:50:48.777+01:00Oracle Database 10g Express Edition - Multiple ConnectionsHave you ever noticed the (apparent) limitation of Oracle Database 10g Express Edition to 10 connections (its a free product). It can be overcome.<br />
<br />
This is how it can be done:<br />
<br />
Open ‘Run SQL Command Line’<br />
Digit: <span style="font-family: "Courier New",Courier,monospace;">connect sys as sysdba</span> (fill the password)<br />
<br />
execute these commands:<br />
<span style="font-family: "Courier New",Courier,monospace;">alter system set processes = 200 scope = spfile;</span><br />
<span style="font-family: "Courier New",Courier,monospace;">alter system set sessions = 300 scope = spfile;</span><br />
<span style="font-family: "Courier New",Courier,monospace;">alter system set transactions = 350 scope = spfile;</span><br />
<br />
restart the database:<br />
<span style="font-family: "Courier New",Courier,monospace;">shutdown immediate;</span><br />
<span style="font-family: "Courier New",Courier,monospace;">startup;</span><br />
And voilá!CodeWizhttp://www.blogger.com/profile/11013250283932483732noreply@blogger.com0tag:blogger.com,1999:blog-6145075381795432498.post-73295119182680584592011-03-31T13:37:00.001+01:002011-03-31T13:38:07.513+01:00Change JTable column header textEver tried to change a column header text and the text doesn't change?<br />
<br />
This is how it can be done:<br />
<br />
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span style="color: black; font-family: "Courier New"; font-size: 10pt;">JTable</span><span style="color: #0000c0; font-family: "Courier New"; font-size: 10pt;"> table</span><span style="color: black; font-family: "Courier New"; font-size: 10pt;">;</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><br />
</div><div class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span style="color: black; font-family: "Courier New"; font-size: 10pt;">DefaultTableModel </span><i><span style="color: #0000c0; font-family: "Courier New"; font-size: 10pt;">model</span></i><span style="color: black; font-family: "Courier New"; font-size: 10pt;"> = </span><b><span style="color: #7f0055; font-family: "Courier New"; font-size: 10pt;">new</span></b><span style="color: black; font-family: "Courier New"; font-size: 10pt;"> DefaultTableModel();</span><span style="color: #0000c0; font-family: "Courier New"; font-size: 10pt;"></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span style="background: #ffffff; color: #0000c0; font-family: "Courier New"; font-size: 10pt; mso-highlight: silver;"><em>model</em></span><span style="color: black; font-family: "Courier New"; font-size: 10pt;">.addColumn(</span><span style="color: #2a00ff; font-family: "Courier New"; font-size: 10pt;">"Directory"</span><span style="color: black; font-family: "Courier New"; font-size: 10pt;">);</span><span style="font-family: "Courier New"; font-size: 10pt;"></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><i><span style="background: #ffffff; color: #0000c0; font-family: "Courier New"; font-size: 10pt; mso-highlight: silver;">model</span></i><span style="color: black; font-family: "Courier New"; font-size: 10pt;">.addColumn(</span><span style="color: #2a00ff; font-family: "Courier New"; font-size: 10pt;">"Files"</span><span style="color: black; font-family: "Courier New"; font-size: 10pt;">);<span style="mso-tab-count: 1;"> </span></span><span style="color: #0000c0; font-family: "Courier New"; font-size: 10pt;"></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span style="color: #0000c0; font-family: "Courier New"; font-size: 10pt;">table</span><span style="color: black; font-family: "Courier New"; font-size: 10pt;"> = </span><b><span style="color: #7f0055; font-family: "Courier New"; font-size: 10pt;">new</span></b><span style="color: black; font-family: "Courier New"; font-size: 10pt;"> JTable(</span><i><span style="color: #0000c0; font-family: "Courier New"; font-size: 10pt;">model</span></i><span style="color: black; font-family: "Courier New"; font-size: 10pt;">);</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span style="color: black; font-family: "Courier New"; font-size: 10pt;">JScrollPane scrollPane = </span><b><span style="color: #7f0055; font-family: "Courier New"; font-size: 10pt;">new</span></b><span style="color: black; font-family: "Courier New"; font-size: 10pt;"> JScrollPane(</span><span style="color: #0000c0; font-family: "Courier New"; font-size: 10pt;">table</span><span style="color: black; font-family: "Courier New"; font-size: 10pt;">);</span><span style="font-family: "Courier New"; font-size: 10pt;"></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><br />
</div><div class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span style="color: #3f7f5f; font-family: "Courier New"; font-size: 10pt;">//Changes Collumn header text</span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span style="color: #0000c0; font-family: "Courier New"; font-size: 10pt;">table</span><span style="color: black; font-family: "Courier New"; font-size: 10pt;">.getColumnModel().getColumn(0).setHeaderValue(</span><span style="color: #2a00ff; font-family: "Courier New"; font-size: 10pt;">"After"</span><span style="color: black; font-family: "Courier New"; font-size: 10pt;">);</span><span style="font-family: "Courier New"; font-size: 10pt;"></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span style="color: #0000c0; font-family: "Courier New"; font-size: 10pt;">table</span><span style="color: black; font-family: "Courier New"; font-size: 10pt;">.getColumnModel().getColumn(1).setHeaderValue(</span><span style="color: #2a00ff; font-family: "Courier New"; font-size: 10pt;">"Before"</span><span style="color: black; font-family: "Courier New"; font-size: 10pt;">);</span><span style="font-family: "Courier New"; font-size: 10pt;"></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span style="color: black; font-family: "Courier New"; font-size: 10pt;"><span style="mso-tab-count: 4;"> </span><span style="mso-spacerun: yes;"> </span></span><span style="font-family: "Courier New"; font-size: 10pt;"></span></div><div class="MsoNormal" style="margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"><span style="color: #3f7f5f; font-family: "Courier New"; font-size: 10pt;">// Forces the header to resize and repaint itself</span><span style="font-family: "Courier New"; font-size: 10pt;"></span></div><div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span style="color: #0000c0; font-family: "Courier New"; font-size: 10pt;">table</span><span style="color: black; font-family: "Courier New"; font-size: 10pt;">.getTableHeader().resizeAndRepaint();</span></div>CodeWizhttp://www.blogger.com/profile/11013250283932483732noreply@blogger.com0