Skip to content

Instantly share code, notes, and snippets.

@terashim

terashim/bq-select-deleting-bom.sql

Created September 19, 2019 09:40
Show Gist options
  • Save terashim/f0d4642f683c4c7fe9777724c40b11b2 to your computer and use it in GitHub Desktop.
Save terashim/f0d4642f683c4c7fe9777724c40b11b2 to your computer and use it in GitHub Desktop.
Download ZIP
BigQueryでデータからBOMを削除する
Raw
bq-select-deleting-bom.sql
-- BigQueryで列 my_column のBOM (Byte Order Mark) を削除
SELECT
REGEXP_REPLACE(my_column, '''\ufeff''', '')
FROM
my_table
@terashim
Copy link
Author

参考: nkfを使う方法 https://qiita.com/tamanugi/items/63fe5cf8e709565777a5

nkf --overwrite --oc=UTF-8 hoge.txt

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