1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Defining a Data Integration
  3. Mapping Members
  4. Format Mask Mapping for Target Values
  5. #FORMAT Mapping Example

#FORMAT Mapping Example

The following is an example that uses all options provided by #FORMAT:

Table 9-3 #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-5ABCX-GROUP