>>---Snip
>>>If I try the string "2000","99 and 44/100ths","12345","ABCDGoldFish","91.21"
>>>
>>>It produces:
>>>
>>>20.00,"99 and 44/100ths",123.45,"ABCDGoldFish",91.21
>>
>>Ed,
>>
>>I think I´ve figured out how it works, and there is a tiny glitch here.
>>
>>oReg.PATTERN = '("\d*)(\d{5}")' &÷ by 10000, right?
>>
>>Works fine til you get to a "number" that is smaller than the divisor.
>>
>>To illustrate:
>>
>>? 1000/10000=0.10 but
>>
>>CVAR='"1000"'
>>oReg.PATTERN = '("\d*)(\d{5}")'
>>? oReg.REPLACE(cVar,'$1.$2')="1000"
>>
>>Could you help me to get around that one?
>>
>>Thank´s
>
>Peter,
>If you don't want my attention why CCing to me ? If you want then provide the lines I requested. Thanks.
>Cetin
Cetin,
Check your mail, it must have arrived by now.
Regards
Peter
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)