Skip to content

bigfunctions > remove_strings

remove_strings

Signature

remove_strings(string, strings_to_remove)

Description

Remove any string of strings_to_remove from string

Examples

select bigfunctions.eu.remove_strings('I can eat candies', ['can', 'eat'])
select bigfunctions.us.remove_strings('I can eat candies', ['can', 'eat'])
select bigfunctions.europe_west1.remove_strings('I can eat candies', ['can', 'eat'])
+----------------+
| cleaned_string |
+----------------+
| I  dies        |
+----------------+