Script still splits final two rows on comma within dollar values

[jaykinghorn]

Hello. I hope this is the correct place to provide feedback. In the exercise Read and Write a CSV file (Part 2) the script in the book still splits the final two dollar amounts in the supplier data that contain a comma to indicate thousands. I've re-typed the script from the book, run it from your supplied scripts from the book repository and run it a third time from the current script on the site and continue to receive the same error. The cost data is split across two columns, pushing date into a sixth and seventh column. Is there a subtlety I've missed?

Thanks,

Jay

[anemochore]

You should modify the CSV file opened in Excel, not in text editor, and then save the file as CSV in Excel too.