thank you, seems like this solution can't keep consistency due to the corrupted data source. Because it corrupt the other row that have raw values like "Mike's..." after replacing double quotes to single quotes as it becomes 'Mike's...' and it will have the same issue again. So my question is: in real world workplace, is it possible to manually fix raw data source from "Brown, Mrs James Joseph (Margaret "Molly" Tobin)" to "Brown, Mrs James Joseph (Margaret 'Molly' Tobin)" before reading it?
... View more