SplitToArray

The SplitToArray function splits a string according to a list of separators and returns a structure that allows iteration in the RuleSet.

SplitToArray ('string','separator/string', boolean, boolean,)

Parameters:

1. String which is to be split.
2. Separator or string which triggers the split.
3. Remove empty values: true¹⁾/false
4. Trim values: true²⁾/false
5. Separator is a string: true/false³⁾, if this optional parameter is used then the second parameter can be specified as a string and triggers the split point(s).

Separation by string

Returns three items, without the last parameter for ‘Separator is a string’ there would be four items:

SplitToArray( 'This is a test invoice

Dagobert Duck
999.999,01', '
', true(), true(), true() )

Returns two items, without the last parameter for ‘Separator is a string’ there would be six items:

SplitToArray( 'Z1, Z2, Z1, Z1, Z1, Z1', 'Z2', true(), true(), true() )

Separation by character

Following returns five structure entries with index 0 - 4 and the values.

SplitToArray("Paul;Mustermann;street 22;99999,city", ";,")

The next one results in value: “street 22”

SplitToArray("Paul;Mustermann;Street 22;99999,City", ";,")/Items[@Index = 2]/@Value

Without specification of the third parameter, empty values are removed, so the next statement returns the value: “99999”.

SplitToArray("Paul;; Street 22,,;99999,City", ";,")/Items[@Index = 2]/@Value

The following delivers: 4

count(SplitToArray("Paul;; Street 22,,;99999,City", ";,")/Items) 

Without removing blank values and without trim, by setting parameters three and four to false, the next example returns the value: “ Street 22”.

SplitToArray("Paul;; Street 22,,;99999,City", ";,", false, false)/Items[@Index = 2]/@Value

Use a string as a separator: @Rg_Betreff = “Test Erechnung
Zeile 2”

SplitToArray( @Rg_Subject, '
', true(), true() )

Note: Build a hierarchy using function SplitToArray()