When you convert attribute values, the attribute icon changes from the attribute icon – – to the convert attribute values icon – .
You cannot change the case, truncate or remove the whitespace of a target key attribute, as this will compromise the key information. However, you can transform the data of a source attribute that is mapped to a target key attribute.
For example, if you are importing information about books, and you set up the ISBN attribute as the target key attribute, then truncating the target information will invalidate any searches you perform on the imported values. However, if you require this information to appear in uppercase within the target key attribute, then you can transform the information in the mapped source attribute:
We recommend that you map your target key attributes to a string field that can completely contain the information, for example one of 256 characters in length.
Alternatively, right-click the required attribute, then click Convert Attribute Values.
The Default Attribute Conversions dialog box changes depending upon the type of data you want to transform. For example, whether the data is a text string or a number.