# Changing mapping delimiters

Abstract

How to change mapping delimiters for fields with multiple values in Sitecore.

When Sitecore stores multiple values in a field, by default it uses a comma (,) to separate the individual values. You can change the delimiter to another character.

If you use special characters as a separator, you must allow those characters on the Sitecore level. You do this by using a patch file to change the ItemNameValidation setting. For example:

<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/">
<sitecore>
<settings>
<setting name="ItemNameValidation">
<patch:attribute name="value">^.*\$</patch:attribute>
</setting>
</settings>
</sitecore>
</configuration> 

### Important

This example allows all characters to be used. It is best practice to only allow the characters you need.

You can change the delimiter for the following fields:

• Relation field mapping - the delimiter for taxonomy values.

• Tag field mapping - the delimiter for values in a tag.

You can change the delimiter Sitecore uses to separate values when it stores multiple taxonomy values.

To change the delimiter:

1. On your Sitecore instance, open the App_Config\Modules\Sitecore.Connector.CMP.config file.

2. In the configuration/sitecore/settings node, set the value of Sitecore.RelationFieldMappingSeparator to the delimiter you want to use. For example, <setting name="Sitecore.RelationFieldMappingSeparator" value=", " />.

3. Save the file.

You can change the delimiter Sitecore uses to separate values when it stores multiple values in a tag.

To change the tag field mapping delimiter:

1. On your Sitecore instance, open the App_Config\Modules\Sitecore.Connector.CMP.config file.

2. In the configuration/sitecore/settings node, change the setting Sitecore.NodeNameSeparator to the delimiter you want to use. For example, <setting name="Sitecore.NodeNameSeparator" value="." \>.

3. Save the file.