-3

I am trying to normalize a column in my table without having an easy way to do it. I tried to use the NORMALIZE function and other solutions posted here, but nothing works.

I would like to get a text normalized from the table like "C\u00f3mo funciona" => "Cómo funciona".

Example of a row in my table

Ricco D
  • 6,873
  • 1
  • 8
  • 18
Julio Ayala
  • 63
  • 5
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Oct 08 '21 at 12:03

1 Answers1

2

The problem was that before saving the data, I made a json_encode that encodes all the data before it can be writted. I only use JSON_QUERY and JSON_VALUE functions of BigQuery to recover and decode the special characters.

Julio Ayala
  • 63
  • 5