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
Next revision
Previous revision
kurs:regular_expression [2014/09/10 21:22]
127.0.0.1 external edit
kurs:regular_expression [2017/03/21 10:02] (current)
admin
Line 1: Line 1:
 +Ermitteln ob in einer Spalte/​Usereingabe eine PLZ steht
 <​code>​ <​code>​
 +select 'ist eine PLZ' from dual 
 +-- select coalesce(plz,​ '​n/​a'​) from adressen
 +-- where regexp_like('​assaa-223421213',​ '​a-2234'​) -- ist enthalten
 +-- where regexp_like('​a-2234',​ '​[Aa]-2234'​) -- grosses oder kleines A
 +-- where regexp_like('​A2234',​ '[Aa][ -]*2234'​) -- * keines oder beliebig viele
 +-- where regexp_like('​A2234',​ '[Aa][ -]{0,​1}2234'​) -- 0 oder eines aus der Gruppe
 +-- where regexp_like('​A2123',​ '[Aa][ -]{0,​1}[0-9]{4}'​) -- {x} genau x mal
 +-- where regexp_like('​A2123',​ '[Aa][ -]{0,​1}\d{4}'​) ​
 +-- statt der Gruppe character class http://​perldoc.perl.org/​perlrecharclass.html
 +where regexp_like('​A2123',​ '​^[Aa][ -]{0,​1}\d{4}$'​) ​
 +</​code>​
  
 +
 +<​code>​
 select 1 from dual where regexp_like('​A- ​  - 1234', '^A(-| ){0,​}[[:​digit:​]]{4}$'​) select 1 from dual where regexp_like('​A- ​  - 1234', '^A(-| ){0,​}[[:​digit:​]]{4}$'​)
  
kurs/regular_expression.1410376975.txt.gz ยท Last modified: 2017/03/21 10:02 (external edit)