Check if value is an integer

[#1]

Hello,

Is it possible to check if a value is an integer when loading the data? I need to divide the number if it's not an integer and do nothing when the number is an integer.

Regards,

Johan

[jagan]

Hi,

Try like this

If(Len(PurgeChar(Value, '1234567890')) = 0, 'Integer', 'Non Integer')

Hope this helps you.

Regards,

Jagan.

[CELAMBARASAN]

You can simply use

Num(KeepChar(Value, '1234567890')) AS NumberField

[#4]

I usually do something like this:    if(myfield=round(myfield),'integer','not integer')

[#5]

Thanks for all your suggestions. I tried if(frac(MyNum)=0 and it did the trick.