Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you can use purgechar() for this.
purgechar(fieldname, ' ') as fieldname_nospaces
you can use purgechar() for this.
purgechar(fieldname, ' ') as fieldname_nospaces