I want to insert a semicolon(;) itself a value for one of the attribute using impex.

[Former Member]

I want to insert a semicolon(;) itself a value for one of the attribute using Impex.

[andyfletcher · Accepted solution]

Wrap your attribute value in quotes

e.g.

 INSERT_UPDATE CmsParagraphComponent;uid[unique=true];catalogVersion(catalog(id),version)[unique=true];content[lang=en]
 ;mycomponent;Default:Staged;"This content has a semicolon ; here's some more ;;;;;"

If you want to have semicolons and quotes in the value then you need to escape the quotes by doubling them up

e.g.

 INSERT_UPDATE CmsParagraphComponent;uid[unique=true];catalogVersion(catalog(id),version)[unique=true];content[lang=en]
 ;mycomponent;Default:Staged;"This content has a semicolon ; and some ""quoted content"""

See points 6 & 7 of CSV Files

[Former Member]

If your attribute isn't a simple string, but a collection you can redefine your delimiter to be something else than semincolons:

 UPDATE Employee; uid[unique=true]; preferences[map-delimiter=|]
 ;FrankColumbo; drink->whiskey|game->poker|colour->beige

[andyfletcher]

+1 for awesome example data!

[Former Member]

Either try to put values in double qutoes (") or you can try html entities for the same.