Validation check on string column where values are double or not

[alt_tush]

Hi,

I have below data table with columns Values. (Values column datatyppe is Vstring 255)

Values
0.11
0.23
2.34
5.44
aa
.
bb
#$
afdf.adfa
5
7
8
1223.56

I want to add checks for double value as this column require entries only for double. If there is no about value found the in other column should update Yes or No like below

Values	Double_Y_N
0.11	Yes
0.23	Yes
2.34	Yes
5.44	Yes
aa	No
.	No
bb	No
#$	No
afdf.adfa	No
5	No
7	No
8	No
1223.56	Yes

Thank you for your help :)

[ShankerV · Accepted solution]

Hi @alt_tush 

One way of doing this

IF REGEX_Match([Values], "\d+.\d+")
THEN "Yes"
ELSE "No"
ENDIF

Many thanks

Shanker V

[binuacs]

@alt_tush Similar to @ShankerV solution

[alt_tush]

Hi Shanker V

It works. Thank you for your quick response. :)

[alt_tush]

Hello Shankar V,

If my column having negative values like -1.23, -234.56 etc it goes to No instead of Yes.

Because negative is also the numeric value. So what need to add in your formula to access negative values too.

I think here i need to change right? 

IF REGEX_Match([Values], "\d+.\d+")
THEN "Yes"
ELSE "No"
ENDIF

Really appreciate your help :)

Thank you,

[ShankerV]

Hi @alt_tush 

Please use the below formula to use - (Negative) numbers also.

IF REGEX_Match([Values], "-{0,1}\d+.\d+")
THEN "Yes"
ELSE "No"
ENDIF

Many thanks

Shanker V