How to read CSV data with fields that contain spaces?

Thank you very much @urbanjost , you explanation is great.
That csv file is just for fun, it is the from the website I read,

In the " Reading CSV Files" section it describes how to read this csv file using type. But obviously the space cause prblem.

I have another small issue, if file contain ’ . ', read will have problem, would you mind, if you have time, quickly point out what is wrong? Thank you very much indeed!