#FORMAT Mapping Example
The following is an example that uses all options provided by #FORMAT:
Table 4-14 #Format Mapping Type Example
Source | Target | Result |
---|---|---|
12345-6789-012-3456ABC-001 | #FORMAT("???-*-GROUP-AA##?#*X-GROUP","-")
Explanation: Take the first three characters of the first segment, take the entire second segment, replace the third segment with the text "GROUP", prefix the fourth segment with AA, drop the third and fourth characters, keep the fifth character, drop the sixth character, keep ABC and add suffix X, replace the fifth segment with the text "GROUP". |
123-6789-GROUP-AA5ABCX-GROUP |