Clean/Remove Spaces

[Luisanabria]

Hi good day

Im working with one excel that has phone numbers like this:

55  6514  4854
55  2211  0014

Does anyone could help me how to remove spaces in the script?  l saw that using TRIM but function says only leading and trailing spaces.

Thanks all

[stevejoyce · Accepted solution]

you can use purgechar() for this.

purgechar(fieldname, ' ') as fieldname_nospaces

[ggijben · Accepted solution]

Hi @Luisanabria , 

An alternative is:

REPLACE(fieldname, ' ', '')