[SOLVED] Transforming nominal data to numeric
I have a regular attribute that I set as polynominal, which contains text describing lengths.
The values for this attribute are things like (quotes not included): "1 cm", "1,5 cm", etc.
I would like to convert the "decimal number" followed by "cm" into a numeric value.
I have looked at and tried the "Parse Number" operator. However this fails. The meta-data
still shows a nominal type and the process complains about a non-numerical value
used in the "cosine similarity measure". I also fail top see how I can inform this operator to
ignore the "cm" text.
Anyone know how I can do this? Any existing operator for this?