How to avoid error when update dataset that contain dot '.' in the field


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:



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"""

Have more questions? Submit a request



Please sign in to leave a comment.