Column rules formula to check for non numerical characters

[Bushra_Akhtar]

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

B

[Emil_Kos]

Hi @Bushra_Akhtar, 

This should help you:

Output:

[Qiu]

@Bushra_Akhtar 
Maybe something like this?

[Qiu]

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

[Emil_Kos]

Hi @Qiu,

I was busy lately and I could make it for only a small portion of my day but I am based in Poland GMT +2. 

@Bushra_Akhtar I think I didn't take into consideration the part that you have a table. Maybe you can use both solutions and use a filter to show non-numerical characters with a row number (so you can easily identify those lines) and you would know how many of them you have.

[Qiu]

@Emil_Kos 
Good to know.
 I am in GMT+9. 😁

[Bushra_Akhtar · Accepted solution]

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+')