How to get numbers with out '/' and '0' ?

[#1]

Hi,

I have data in table box as below

one value is 32089/5409836  and another value 0464765

How can I get the output as below

32089

464765

Can anyone please suggest me as this is very urgent work. Please suggest.

[maxgro · Accepted solution]

SubField(field, '/',1)+0

[MarcoWedel]

=Num(SubField(yourfield,'/',1))

[#4]

Thanks.

[#5]

Thanks as well.