Symptom

When updating Dataset in CSV file via. FC Connect, it throws an error message when the data contain dot '.'  in the field such as:
[Error] File '"C:\HotFolder\DataSets\PurchaseOrderLines.csv"' contains errors:

Answer

Only one character that should be escaped is a double quote, other special characters can be processed without additional actions. To escape the double quote you should add double quotes at the beginning and at the end of the cell with your " character and add the additional double quote right before your character that should be escaped.

For example,

"2 PLY TISSUE PAPER 4.5"" X 4"""