This shows you the differences between two versions of the page.
Both sides previous 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}$') | ||