Data is like string type as $0.6M or $0.9-- how to get only values

Four Stars

Data is like string type as $0.6M or $0.9-- how to get only values

Data is like string type as  $0.6M or $0.9-- how to get only values such as 0.6 or 0.9 
I tried in tmap StringHandling.EREPLACE(StringHandling.EREPLACE(row2.Matrix,"$",""),"M","") 
But i am getting it as 
$0.60 
$ is still there. Please suggest.
Thanks,
Rahul
Four Stars

Re: Data is like string type as $0.6M or $0.9-- how to get only values

getting output as $0.6 still dollar sign is there .
In previous post copy paste error
Community Manager

Re: Data is like string type as $0.6M or $0.9-- how to get only values

try this expression:
(row2.Matrix.replace("$", "")).replace("M", "") 
----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars

Re: Data is like string type as $0.6M or $0.9-- how to get only values

Hi Shong,
Many thanks for fast and accurate response. The solution worked .Smiley Happy
Rahul