Clean up text, keep only numbers

1

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.

image
image185×537 6.73 KB

2

And then my head woke...

image
image328×200 2.3 KB

3

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

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

Even better, thanks :slight_smile:

5

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

6

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

image
image173×299 2.17 KB

image
image647×380 12.2 KB

7

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