Regex with wildcard *

1

Hi,

A regex like “\d*” in the regexmatch() formula does not work.

Why is the wildcard not supported ? Is there a workaround ?

Thanks
Nikolaas

2

Hi Nikolaas,

What exactly doesn’t work?

3

Hi Dmitry,

I want to remove the numbers at the end of some labels. I would like to use a regex or text function to remove the chars depicted in bold below. So I was experimenting with the regexmatch(). Apperently now it works so I suppose I was doing something wrong in the regex itself…

image

image

Sample data:

energiebron1
hoeveelheid1000
energiebron10
V12_vector_123