1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. Integration Tasks
  3. Working with Import Formats
  4. Adding Import Expressions
  5. Import Expression Types
  6. Padding Fields with Trailing Fills

Padding Fields with Trailing Fills

The Fill=TrailingFill expression is used to fill fields with trailing characters. Text values that are shorter than the specified fill expression are padded, as directed by the fill expression. For example, if the account number is 103950- and the expression Fill=000000000 is used, the account number after import is 103950-000. Another example is an account number of 243150 with the expression Fill=111111111. The account number after import is 243150111.