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

Comments

2 comments

  • 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
  • Stevo Vasiljevic

    U can also simply copy/paste fields from excel into Notepad and somthing, it will keep structure and all special characters that otherwise will be omitted during export.

    0
    Comment actions Permalink

Please sign in to leave a comment.