Problem in string to double data conversion

KNIME Analytics Platform
1

Hello,

I am having some problems in string to double conversion. I have loaded a data file. As a column has some rows values in string data type. I tried to convert from string to double data type. Partially some values were converted but still for some values its showing error " Values in 8646 cells could not be parsed, first error: '27. Jan' ". I am having problem in converting this value specifically. Rest all were converted. How do I proceed?

Thanks!

2

27. Jan isn't compatible with a double. Is this column really containing doubles and not partial dates? 

You could strip out the numeric charachters at the start into a new cell and then convert this to a double?