The Source and Target Value expressions can have one or more special characters. Special characters are supported for “Like” mappings only.
Asterisk (*)
An asterisk (*) represents the source value. The asterisk (*) can be prefixed or suffixed by one or more characters, which filters the source value by that prefix or suffix and strips those characters from the source expression.
Question Mark (?)
The question mark (?) strips a single character from the source value. You can use one or more question marks (?) in the expression. You can also use question marks in combination with other expressions. For example, (*, <1>, <2>, <3>, <4>, <5>).
<1>, <2>, <3>, <4>, <5>
Processes rows that have concatenated values and extracts the corresponding segment value (identified by the segment number). Each segment is separated by an underscore character (_). Only one segment value can be extracted in a source value expression.
Note: | <1>, <2>, <3>, <4>, <5> can be used with a question mark (?) but cannot be used with an asterisk (*). |
<BLANK>
Processes only rows that contain the blank character (space). This is true for both single and concatenated segment or chartfield dimension mappings.
Note: | <BLANK> cannot be used with other source expression or characters. |
Table 11. Examples of Expressions Using Special Characters
| Special Character(s) Used | Source Value | Target Value | Result | Notes |
|---|---|---|---|---|
* | * | 1000 | 1000 returns 1000 WXYZ returns 1000 | In this example, ERP Integrator processes all rows and overrides the source value with a default value of 1000. In this expression, WXYZ would also return 1000. Because you entered an asterisk for the source value it would replace any source value with the target value of 1000. |
* | * | * | 1000 returns 1000 WXYZ returns WXYZ | In this example, ERP Integrator process all rows and replaces the source value as is. |
* | A* | * | A1000 returns 1000 | Processes only source values starting with the letter “A.” |
* | *_DUP | * | 1000_DUP returns 1000 | Processes only source values ending with “_DUP.” |
? | ?* | * | A1000 returns 1000 B2000 returns 2000 | This result processes only source values of one or more characters in length. |
? | *???? | * | 1000_DUP returns 1000 A1000 returns A | This result processes only source values of four or more characters in length. |
<1>, <2>, <3>, <4>, <5> | <1> | * | 01_420 returns 01 | |
<1>, <2>, <3>, <4>, <5> | <2> | * | 01_420 returns 420 | |
<1>, <2>, <3>, <4>, <5> | <3> | * | 01_420_AB_CC1_001 returns AB | |
<1>, <2>, <3>, <4>, <5> | ?<1> | * | A01_420 returns 01 | |
<BLANK> | <BLANK> | [None] | ' ' returns [None] '01_ ' returns [None] | Single quotes are shown for illustration only. |