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

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:

mceclip0.png

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

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.