Defining split string expressions

  1. Select BPA Designer > Operations > Expressions.
  2. In the Document field, select the input business document for which to define an expression.
    For accounting framework integration, the list displays transactional document registrations. For a flexible output integration, both the master data and transactional document registrations are shown.
  3. Click Add.
  4. Specify this information:
    Name
    Specify a unique name that identifies the expression. Valid characters are a–z, A–Z, and 0–9. The first character should be an uppercase letter. The maximum length is 20 characters.
    Type
    Select Text.
    Note: A Statement field is displayed containing these controls:
    • Operand Types - possible values are Attribute, Expressions and Fixed Value.
    • Operators
    • Statement Control buttons - use these buttons to navigate and perform editing functions on the statement.
  5. Click Split.
  6. Select the operand type. This refers to the value that will be split. Possible values are:
    • Attribute
    • Expression
    • Fixed Value
  7. Specify the information for the remaining fields. The displayed fields depend on the selected argument type.
    For Attribute argument:
    Mapping
    Select the document registration. This list is dynamic. For accounting framework integration, the list displays transactional document registrations. For a flexible output integration, both the master data and transactional document registrations are shown.
    Attribute
    Select the attribute. This list is dynamic. It displays the attributes associated to the selected document registration.
    For Expression argument:
    Name
    Select the expression. This list is dynamic. It displays the search template, text, date, and REST API expressions associated to the selected Document. For search template espressions, only expressions returning an alphanumeric single result are displayed.
    For Fixed Value argument:
    Value
    Specify a fixed numeric or text value.
  8. Select the split operation in the Split By field. You can select these values:
    • Split by Index - Select this option for values with identified starting or ending character positions.
    • Split by Delimiter - Select this option for values separated by delimiters.
  9. Specify the information for the remaining fields. The displayed fields depend on the selected split operation.

    If you select Split By Index, specify character positions that will define the range to be extracted from the operand value.

    Start
    Specify a numeric value. This refers to the starting character from the left of the operand value.
    End
    Specify a numeric value. This refers to the ending character from the left of the operand. Alternatively, leave this field blank to extract string up to the end or last character of the operand value.
    If you select Split By Delimiter, specify this information:
    Delimiter
    Specify a special character or a sequence of special characters, except for apostrophe and single quote. This refers to the character that separates field values from one another.
    Field Position
    Specify a numeric value. This refers to the specific location of a field value within the delimited text. For example, in a GLNominalAccount attribute value of "100001@0936" which consists of main account and sub-account separated by @, the field positions are:
    • 1 for the main account, 100001
    • 2 for the sub-account, 0936
  10. Click Add.
    The statement box is populated with the split operation.
  11. Click Save.