Column with String and Int with decimals

[Rahim_Bhatia]

Hello. I need help with data that is coming from excel where a column “Weight” has string and numbers with decimals (please see example below). My issue is that it doesn’t like decimals but when I change the decimals to whole number it works fine. From the example below I want to select Natalie and Bee. Can you help pls.

I have used the following

If (Weight).IsNumeric
If CINT (Weight) > 32.99

Name Age Weight

Sarah Smith 4 23.76
Ryan Orr 6 not available
Bee Sunday 5 34.32
David Toes 4 31.37
Natalie Sanders 7 37.33
Jeremy Gold 5 not available

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@Rahim_Bhatia you could be if
weight.isnumeric and cdbl(weight) >32.99

[Yoichi]

Hi,

Hope the following sample helps you.

Double.TryParse(CurrentRow("Weight").ToString,new Double) AndAlso Double.Parse(CurrentRow("Weight").ToString)>32.99

Sample20221208-4.zip (9.4 KB)

Regards,