bigfunctions > remove_extra_whitespaces

remove_extra_whitespaces

Signature

remove_extra_whitespaces(str)

Description

Remove unwanted whitespaces (inspired from re_data dbt repo)

Examples

EUUSeurope-west1

select bigfunctions.eu.remove_extra_whitespaces('Hi   Madison  and Mateusz!\n How are you doing?')

select bigfunctions.us.remove_extra_whitespaces('Hi   Madison  and Mateusz!\n How are you doing?')

select bigfunctions.europe_west1.remove_extra_whitespaces('Hi   Madison  and Mateusz!\n How are you doing?')

+--------------------------------------------+
| cleaned_string                             |
+--------------------------------------------+
| Hi Madison and Mateusz! How are you doing? |
+--------------------------------------------+