In a Bigquery table I have the same value but with 2 different type of fonts (ℂ and Cartagena), for a data cleaning process how can I put it all in one type of font, since it filters as 2 different values?
1 Answers
Use NORMALIZE function as in below example
with your_table as (
select 'ℂ' col union all
select 'Cartagena'
)
select *, normalize(col, NFKC) normalized_col
from your_table
with output
Related