Trim the format

[apthansh]

How can I just get 4.25 from the below formatted number ?

float;#4.25000000000000

Thank you,

Supritha.

[aarkay29]

May be this

num('4.250000000','0.00')

[apthansh]

I tried mid(float;#4.25000000000000,8) and that worked.

Thank you though