SQL RegEx

SQL RegEx : Character Classes


  1. Character Classes or Character Sets are used to define a list of characters to be used inside a RegEx.
  2. Represented using square brackets […]
  3. Characters inside the square brackets are “case sensitive”.
  4. The geology 210-060 questions of the surrounding country possesses little interest. Throughout the coast of Brazil, and certainly 210-060 questions for a considerable space inland 300-101 demo 210-060 questions from the 300-075 study guides Rio Plata 210-060 questions to Cape St. Roque, lat. 5S., a distance of more than 2000 geographical 300-101 demo miles, wherever solid 300-101 demo rock occurs, 300-075 study guides it belongs to a 300-075 study guides granitic formation. 300-075 study guides 300-075 study guides The circumstance of this 210-060 questions enormous area being thus constituted of materials, which almost every geologist believes have been 300-101 demo 210-060 questions crystallized by the action 300-101 demo of heat 210-060 questions 300-075 study guides under pressure, gives 210-060 questions rise to many curious reflections. Was 210-060 questions this effect produced beneath the depths 300-075 study guides of a profound ocean? 300-101 demo Or did a covering 210-060 questions of strata formerly extend over it, 300-075 study guides which has 210-060 questions since 300-101 demo been removed? Can we believe that any power, action for a time short of infinity, could have denuded the granite 300-101 demo over 300-101 demo so many 300-101 demo thousand 210-060 questions square leagues?

    A small forest in my memorythis is a forest that not as large as a collage, but it 210-060 questions is all of my childhood. 210-060 questions 300-075 study guides 210-060 questions in summer, i can smell sweet from different flowers, and play games with friends behind 210-060 questions 300-101 demo the 300-101 demo trees. i also can hear the sounds 300-101 demo of 300-075 study guides owl and 300-075 study guides birds. 300-101 demo 300-075 study guides 300-101 demo and rabbites and hedgehog. in winter, there is 300-075 study guides a 300-101 demo white world, i 300-075 study guides can play snow with 300-075 study guides my 300-075 study guides friends, and make snow man. there are most improtatant memory for me,and i can not forget this period of my life.

Character class Matches (one character) More details
[abc] a or b or c
[AbXd] A or b or X or d
[a-f] lower a to lower f => a or b or c or d or f Hyphen “-” defines the range
[a-zA-Z0-9] lower a to lower z OR

upper A to upper Z OR

digit 0 to digit 9

Multiple Hyphens are used for multiple range lists
 [^abc]  NOT a and NOT b and  not C  ^ is used for “NOT” equals to
 [a-d[m-p]]  lower a to lower d OR

lower m to lower p

 UNIOIN
 [a-g&&[efghij]]  e or f or g  Intersection
 [1-3&&[3-6]]  3  Intersection
 [a-z&&[^bc]]  a or ( d to z) ==>

a-z but not ( b  or c)

 Subtraction

 

Examples

 

 

Source Text RegEx Match found ? Details
telegram [ab] YES This RegEx tries to match if source text contains either character “a”, or “b”.
call007 now [0-9] YES This RegEx tries to match if source text contains any digit from 0 to 9.
this is not ok [0-9] NO Source text does not contains any digits.
ppppppp [a-d[mp]] YES This is union so match is found for “p”.

 


IBM i developer.

View Comments
There are currently no comments.