Exclude Value after Decimal while loading

[#1]

Dear All,

I have some data in Excel Sheet,where in a Field i some data with decimal values i want to exclude the decimal value while loading.

Ex : field name as Transactional_Amount : data are there like 125.25,1000.65,258.003.........

I want to exclude decimal values while loading data in QV application so, that when in application i check field Transactional Amount it should show data like : 125,1000,258

Please help its Urgent.

Kind Regards,

Pranav

[disqr_rm]

You may use FLOOR() function, like:

LOAD floor(125.25) as f AutoGenerate 1;

[#3]

Or you can use subfield()

subfield(Transactional_Amount, '.', 1) as Transactional_Amount

but it's better to use floor() as Rakesh suggest

[#4]

Thanks Rakesh and Muncho it Works through Floor()

Regards,

Pranav