It was my understanding that specifying [[unct:]] as a regexp would find all special characters: ! ' # S % & ' ( ) * + , - . / : ; < = > ? @ [ / ] ^ _ { | } ~
However, when I run this code, it shows it's not a match:
Am I missing something?
However, when I run this code, it shows it's not a match:
PHP Code:
with tmp as (
select
'~' as string
from sysibm.sysdummy1
)
select
tmp.string
, regexp_count(tmp.string,'[[:punct:]]') as punctmatchcount
, regexp_count(tmp.string,'[^[:punct:]]') as punctunmatchcount
from tmp
;
Comment