Skip to content

Instantly share code, notes, and snippets.

@kjunichi

kjunichi/20161214.md

Last active January 13, 2017 05:55
Show Gist options
  • Save kjunichi/bce15966eba6afc902a7d55e57e8e213 to your computer and use it in GitHub Desktop.
Save kjunichi/bce15966eba6afc902a7d55e57e8e213 to your computer and use it in GitHub Desktop.
Download ZIP
2016/12/14
Raw
20161214.md

半角カタカナを抽出

length(
trim(
regexp_replace(
regexp_replace(
regexp_replace(
regexp_replace(table.columnName, '[[:digit:]]', NULL),
'(-|\_|\@|\.)+',NULL),
'[A-Z]',null),
'[a-z]',null)
)
)>0

関連

アクセス解析タグ

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment