User Tools

Site Tools


kurs:regular_expression

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
kurs:regular_expression [2008/12/10 12:02]
mh
kurs:regular_expression [2014/09/10 21:22]
127.0.0.1 external edit
Line 1: Line 1:
 +<​code>​
  
 +select 1 from dual where regexp_like('​A- ​  - 1234', '^A(-| ){0,​}[[:​digit:​]]{4}$'​)
 +
 +select regexp_instr('​A- ​  - 1234', '^A(-| ){0,​1}[[:​digit:​]]{4}$'​) from dual
 +
 +select regexp_substr('​am parkweg 27, A-1234, Stadtdorf', ​
 +                     '​A(-| ){0,​1}[[:​digit:​]]{4}'​) as plz from dual
 +
 +select regexp_instr('​Mark Hofstetter',​ ' ') from dual
 +
 +select 1 from dual where '​Mark'​ like '​%M%';​
 +
 +select regexp_replace('​Blastr. 27', '​[[:​blank:​]]+',​ ' ') from dual;
 +
 +select regexp_replace(regexp_replace('​Bla ​  ​Str. ​     27', '​(str).', ​ '​\1asse',​1,​1,'​i'​),​ '​[[:​blank:​]]+',​ '​_'​) from dual;
 +
 +
 +regexp_like(PLZ,​ '^A(-| ){0,​}[[:​digit:​]]{4}$'​) or regexp_like(PLZ,​ '^D(-| ){0,​}[[:​digit:​]]{5}$'​)
 +</​code>​
kurs/regular_expression.txt ยท Last modified: 2017/03/21 10:02 by admin