-1

In redshift, I'm trying to to regexp_replace strings like the following example to maintain apostrophes, spaces, alphanumeric, but remove non-english-standard characters like Â. Is this possible?

'He's interested in addressing the challenges of #energy &  #climate change'

to

'He's interested in addressing the challenges of energy climate change'
a_horse_with_no_name
  • 440,273
  • 77
  • 685
  • 758
user2961298
  • 1

1 Answers1

-1

Use /[^\x00-\x7F]/g for non-ASCII characters.

Elvin Amrahli
  • 24
  • 2