Prepare Dataset (polynominal to integer)

nevs

Hello, 
I have a Fifa19 Dataset from kaggle and I want to turn value & wage, as you can see in the screenshot, from polynominal to integer. 
So I guess I have to remove the wierd characters (in the .csv it is €) and the M/K. 



How can I do that? 

/edit 

In addition, I would like to have height and weight displayed in cm or kg instead of inches and lbs.


Thanks!

sgenzer

hi @nevs  probably the easiest is either to use Turbo Prep or the Replace operator.

sgenzer

hi @nevs  probably the easiest is either to use Turbo Prep or the Replace operator.