Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When you are adding a file or directory data item to Sync, the Ignore Quotes option is available to handle files containing embedded quotes in the data, such as a representation of inches. For example, a 12" ruler.

When the Ignore Quotes checkbox is NOT selected, quotes in data are interpreted as the opening quotes of a single string. This can cause a single cell to be populated with rows of data, until the next set of quotes is found. The difference is shown in the tables below.

Source data - ID

Source data - product

Output when the Ignore Quotes option is NOT selected

1

3.5” wrench

3.5” wrench Hammer Bolts 2.5”

2

Hammer

screws

3

Bolts

4

2.5” screws

If you select the Ignore Quotes checkbox, any embedded quotes are treated as normal characters, and the data is written out correctly.