bigfunctions > replace_special_characters

replace_special_characters

Signature

replace_special_characters(string, replacement)

Description

Replace most common special characters in a string with replacement

Examples

EUUSeurope-west1

select bigfunctions.eu.replace_special_characters('%♥!Hello!*♥#', '')

select bigfunctions.us.replace_special_characters('%♥!Hello!*♥#', '')

select bigfunctions.europe_west1.replace_special_characters('%♥!Hello!*♥#', '')

+----------------+
| cleaned_string |
+----------------+
| Hello          |
+----------------+