The following example refers to the use of concatenated sources on the Define Instrument Type Fields dialog, where you set source fields as instrument type fields. You can also use concatenated sources in any field in the Import Link window, when mapping source and target columns.
Suppose that your data source contains the following columns: cmpnt_func_type_name column holding source instrument type names and cmpnt_func_type_desc column holding source instrument type descriptions. On the Define Instrument Type Fields dialog, you can move both columns to the Instrument type description pane and specify sub-string parameters as follows:
cmpn_func + cmpnt_name(2,5)
The imported instrument type description is made up of the source instrument type plus five characters of the source description starting from the second character.
Now, suppose that you specify the following concatenated string:
cmpn_func + cmpnt_name(2)
The imported instrument type description is made up of the source instrument type plus all the characters of the source description starting from the second character.