>Hi Vinod,
>
>>What is the best way to replace # Signs after . with 0 ??
>
>I belive the best way (with strings of course) is
>
lcInput='###,###,###.##'
>lcOutput=JUSTSTEM(lcInput)+'.'+STRTRAN(JUSTEXT(lcInput), '#', '0')
Much simpler.
Mike,
That's terrific, and to echo my friend Dragan, I wish I'd of thought of it.< g > However, there's an even simpler way with foxtools (or VFP 6.0)
lcInput= '###,###,###.##'
lcOutout = FORCEEXT(lcInput, '00')
George
Ubi caritas et amor, deus ibi est