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. The wild card takes whatever is present in the source and puts it in the target column, usually adding a prefix.
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: A?? (finds members that start with A and have any two characters following and selects the members or strips off the two characters. You see these examples in the table below.)
<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 13. Examples of Expressions Using Special Characters
| Special Character(s) Used | Mapping Type | Source Value | Target Value | Result | Notes |
|---|---|---|---|---|---|
* | Data Load | * | 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. |
* | Data Load working off Stripping | * | * | 1000 returns 1000 WXYZ returns WXYZ | In this example, ERP Integrator process all rows and replaces the source value as is. |
* | Stripping | * | A | 101 returns A101 | Processes only source values starting with the letter “A.” |
* | Stripping | *_DUP | * | 1000_DUP returns 1000 | Processes only source values ending with “_DUP.” |
? | Stripping | ?* | * | A1000 returns 1000 B2000 returns 2000 | This result processes only source values of one or more characters in length. |
? | Stripping | *???? | * | 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> | Data Load | <1> | * | 01_420 returns 01 | |
<1>, <2>, <3>, <4>, <5> | Data Load | <2> | * | 01_420 returns 420 | |
<1>, <2>, <3>, <4>, <5> | Data Load | <3> | * | 01_420_AB_CC1_001 returns AB | |
<1>, <2>, <3>, <4>, <5> | Stripping | ?<1> | * | A01_420 returns 01 | |
<BLANK> | Data Load | <BLANK> | [None] | ' ' returns [None] '01_ ' returns [None] | Single quotes are shown for illustration only. |