Clean up text, keep only numbers

There must be a way, but I cant find it…
I just need to clean up column “Organisasjonsnr” so that the values only contains digits, no spaces or characters.

And then my head woke…

image

You can use the keepchars() function. For instance:

keepchars([Organisasjonsnr], "0123456789")
1 Like

Even better, thanks :slight_smile:

If you wanted to follow this way, you could use the “Replace with lookup” action to remove all occurrences of keywords from a list.

This is also handled well in the “cleanup” action. I just used it on a project earlier today.

image

image

My apologies. The cleanup action doesn’t work when a cell is comingled with text/numbers because the entire cell is considered text.