Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 3 of 3

Thread: Can I escape charaters in Excel Product import spreadsheet?

  1. 02-25-2010, 09:27 AM #1
    MikeI is offline Junior Member
    Join Date
    Jan 2006
    Posts
    25

    Default Can I escape charaters in Excel Product import spreadsheet?

    I have some categorys that have '/' slashes in their names and when I import using the Excel spreadsheet the category name is split into seperate categories.
    Is there a way to escape the slash characters in the Excel template?
  2. 02-25-2010, 09:49 AM #2
    Mike The Last Boyscout is offline User
    Join Date
    Nov 2008
    Posts
    254

    Default

    I believe you can do that by putting the information in CDATA tags. Try it out and see if it works for you!
  3. 02-25-2010, 10:44 AM #3
    MikeI is offline Junior Member
    Join Date
    Jan 2006
    Posts
    25

    Default

    I was able to add & #47 to represent the slash character.

    ISO 8859-1 character set link
    http://htmlhelp.com/reference/charset/
    Last edited by MikeI; 02-25-2010 at 10:50 AM. Reason: formatting was incorrect