How to remove \n���� from a sentence in bigquery

Question

I want to remove \n���� from a sentence in biquery. I have used the following query REGEXP_REPLACE(Sentence, r'([^\p{ASCII}]+)', '') AS Senetnce. It is removing only the question marks. How do I remove \n also? Thanks.

Answer 1

try below

select regexp_replace(Sentence, r'\n|[^\p{ASCII}]+', '')     

if apply to your Question's title How to remove \n���� from a sentence in bigquery - output is