Validation check on string column where values are double or not

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

Workflow

Developer

Gallery

Developer Tools

Settings

Error Message

Custom Tools

Common Use Cases

Best Practices

Bug

Batch Macro

Join

Interface Tools

Iterative Macro

Behavior Analysis

Accepted answers

ShankerV

Hi @alt_tush

One way of doing this

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

Many thanks

Shanker V

All comments

ShankerV

Hi @alt_tush

One way of doing this

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

Many thanks

Shanker V

binu_acs

@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,

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703