Remove dollar sign from nominal currency value?
Hi. I have a nominal attribute containing a currency value including a dollar sign (e.g. $1.23). I would like to convert this attribute to a simple Numerical value without the dollar sign (e.g. 1.23) to use in subsequent calculations.
What is the easiest way to do this conversion in Rapidminer? I was trying to remove the "$" from the text string before parsing the number, but I'm presuming there has to be a simpler way to do this conversion.............................?
Any tips would be appreciated, thanks.