When defining the import mapping, you can use various string operators in the Source Name field of the Import Link window. The following string operators are available:
Operator |
Description |
Example |
---|---|---|
'...' |
Single quotes. You must enclose any fixed string in single quotes if you do not want to link the source data directly. |
'101-FT-100' — Imports a specific tag number. |
(n,n) |
Sub-string operator. This operator allows you to transfer a sub-string of a source field value by adding in parentheses the string parameters: the starting character and the string length. |
cab_name (3,2) — Indicates that you want to transfer two characters from the cab_name field, starting from the third character. |
& |
Ampersand character. This character allows you to trim any leading or trailing spaces in the imported value. You must add the & character before the field value in the link. |
&tag_name (5,5) — In this example, the source field (tag_name) is a string representing an entire tag name such as 101-FT -100 (where the instrument type segment can be up to 5 characters long and includes trailing spaces). This example includes a sub-string of 5 characters in length starting from the 5th character, which in this case is 'FT ' (with 3 trailing spaces). The '&' character preceding the string ensures that these trailing spaces are trimmed, so that the imported string will be 'FT'. |
# |
Pound character. The # character, preceded and followed by a + character (...+#+...) indicates the end of the current line so that the imported value following #+ appears on the next line. |
spec_note1+#+spec_note2 — Imports two spec note from a predefined source fields and displays the second note on a new line. |
You can use any combination of the string operators in an import link.