Remove special characters

Hello, I’m need to remove some special characters. I tried use replace function but I have some questions.

I have an number like 123.456.789-01, and I need it to stay like this 12345678901

I find the solution

2 Likes

Something that isn’t very obvious is that replace() also supports regular expression, so you could do it like this as well, just add characters you might encounter between the brackets:

image

Or something like this to account for other non-word characters that might pop up:
image

Both these examples would result in 12345678901

1 Like