Strategies for dealing with quote marks from Excel files for Text Import

Comments

1 comment

  • Birger Øvensen

    Since FotoStation is using the semi-colon as default separator for items in a bag field, we understand that this becomes a problem after editing the data in Excel. We have now implemented improvements where we trim away the quote marks surrounding the whole text. On export, quotes are now encoded as " this way we avoid removing quotes which should be in the text.When importing from other systems, just replace quotes (") in the original text with " before the import.


    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk