0

More than 3 years have passed since last update.

【BigQuery】ラテン文字の正規化

BigQuery

Posted at 2022-04-13

概要

ラテン文字をアルファベットに正規化したかったときのメモ

BigQuery

WITH data AS(
  SELECT 'èòa™' AS text
)

SELECT
  text,
  REGEXP_REPLACE(NORMALIZE(text, NFD), r'\pM', '') nfd_result,
  REGEXP_REPLACE(NORMALIZE(text, NFKD), r'\pM', '') nfkd_result
FROM data

結果

1	 èòa™   eoa™   eoaTM

参考

Link

0

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

0