How to catch integer from Text?

bangswit

hi all , How to catch integer from Text?
for example if i have data ' 9.0000' then it means 9
and if i have data ' ' it means 0
thanks

pduck

Try EVALUATE() but to get 9 out of 9.000 it depends on your machines local settings if "." ist definied as decimal sign. If not you need to program a parse loop.

bangswit

the problem is.... how to ignore spaces...??

vijay_g

Have you tried with string functions?

bangswit

vijay_g wrote:

Have you tried with string functions?

how to do that?

navuser1

bangswit wrote:

vijay_g wrote:

Have you tried with string functions?

how to do that?

Dear bangswit,

What will be the integer value of the text 9.876 ??

bangswit

navuser1 wrote:

bangswit wrote:

vijay_g wrote:

Have you tried with string functions?

how to do that?

Dear bangswit,

What will be the integer value of the text 9.876 ??

done already...
i change to decimal
so using delchr