Column rules formula to check for non numerical characters

Hi,

I am trying to add a condition to my table to one of the columns to identify any characters which are non numerical. Does anyone know the best formula to use for this within the table tool? .

Thanks in advance

Help

Accepted answers

Bushra_Akhtar

Thanks for your help everyone. I managed to find a formula in another post which has worked and it means I can keep it within the table rules.

!REGEX_Match([Field Name], '\d*\.{0,1}\d+')

All comments

Emil_Kos

Hi @Bushra_Akhtar,

This should help you:

Output:

Non Numerical.yxmd

Qiu

@Bushra_Akhtar
Maybe something like this?

New Workflow2A.yxmd

Qiu

@Emil_Kos
Which Time Zone are you in anyway?
I can see you in the morning and night? 😁

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703