SXI Forum

MarekR

Member

Registered: 21-02-2019

Posts: 19

Rules: Concatenation

This rule combines separate strings with a customisable delimiter.

Example:

Street= “20 Peltier Dr”

Suburb= “Sunninghill”

PostalCode= “2191”

We will use the above elements to create a single element called "Address".

<sxi:Field name="na">
 <sxi:Rules>
    <sxi:Concatenation>
         <sxi:Delimiter>, </sxi:Delimiter>
         <sxi:Fields>
           <sxi:Field>Street</sxi:Field>
           <sxi:Field>Suburb</sxi:Field>
           <sxi:Field>PostalCode</sxi:Field>
         </sxi:Fields>
     </sxi:Concatenation>
 </sxi:Rules>
 <sxi:OutputField>Address</sxi:OutputField>
</sxi:Field>

Notice the "<sxi:Field name="na">" does not need a value as you wont need any information from it.

After using the above config "Address" will look as follows:

Address = "20 Peltier Dr, Sunninghill, 2191"

IMPORTANT:
if you want to use the Concatenation "sxi:Field" as a normal string(not an element), use the "staticValue" attribute.(See attributes below for more info)

Example:

<sxi:Field name="na">
 <sxi:Rules>
    <sxi:Concatenation>
         <sxi:Delimiter>, </sxi:Delimiter>
         <sxi:Fields>
           <sxi:Field staticValue="yes">Street</sxi:Field>
           <sxi:Field staticValue="yes">Suburb</sxi:Field>
           <sxi:Field staticValue="yes">PostalCode</sxi:Field>
         </sxi:Fields>
     </sxi:Concatenation>
 </sxi:Rules>
 <sxi:OutputField>Address</sxi:OutputField>
</sxi:Field>

this config will make "Address" look as follows:

Address = "Street, Suburb, PostalCode"

Attributes:

• staticValue:
  If set to yes it will use the "Field"s configuration as a string not as an element.