Finds a substring of specified length starting at a specified point in the string.
Input Parameter Sequence |
Description |
|---|---|
1 |
Source column in which to find a substring. |
2 |
Position in the new string where the substring starts. |
3 |
Length of substring. |
Output Parameter Sequence |
Description |
|---|---|
1 |
Microsoft Dynamics CRM field in which to put the substring. |
Sample Data Map Using Substring
This sample shows creating a substring, new_file_folder_label, based on the first four characters of a contact's last name.
<Map Name="sample_contact_substring">
<Description>Sample map showing Substring</Description>
<EntityMaps>
<EntityMap TargetEntityName="contact" SourceEntityName="Source_contact">
<AttributeMaps>
<AttributeMap>
<SourceAttributeName>Source_lastname</SourceAttributeName>
<TargetAttributeName>lastname</TargetAttributeName>
<ProcessCode>Process</ProcessCode>
<AttributeMap>
</AttributeMaps>
<TransformationMaps>
<TransformationMap>
<TransformationTypeName>Microsoft.Crm.Transformations.Substring</TransformationTypeName>
<ProcessCode>Process</ProcessCode>
<InputParameterMaps>
<SingletonInputParameterMaps>
<SingletonInputParameterMap>
<ParameterSequence>1</ParameterSequence>
<DataTypeCode>Reference</DataTypeCode>
<Data>Source_lastname</Data>
</SingletonInputParameterMap>
<SingletonInputParameterMap>
<ParameterSequence>2</ParameterSequence>
<DataTypeCode>Value</DataTypeCode>
<Data>0</Data>
</SingletonInputParameterMap>
<SingletonInputParameterMap>
<ParameterSequence>3</ParameterSequence>
<DataTypeCode>Value</DataTypeCode>
<Data>4</Data>
</SingletonInputParameterMap>
</SingletonInputParameterMaps>
<ArrayInputParameterMaps/>
</InputParameterMaps>
<OutputParameterMaps>
<OutputParameterMap>
<ParameterSequence>1</ParameterSequence>
<Data>new_filefolderlabel</Data>
</OutputParameterMap>
</OutputParameterMaps>
</TransformationMap>
</TransformationMaps>
</EntityMap>
</EntityMaps>
</Map>