====== SplitToArray ======

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

==== Syntax: ====

<code>SplitToArray ('string','separator/string', boolean, boolean,)</code>

Parameters:
  - String which is to be split.
  - Separator or string which triggers the split.
  - Remove empty values: **true**((default Value))/false
  - Trim values: **true**((default Value))/false
  - Separator is a string: true/**false**((default Value)), if this optional parameter is used then the second parameter can be specified as a string and triggers the split point(s).
===== Example: =====



**Separation by string** 

Returns three items, without the last parameter for ‘Separator is a string’ there would be **four** items:
<code>SplitToArray( 'This is a test invoice&#xD;&#xA;&#xD;&#xA;Dagobert Duck&#xD;&#xA;999.999,01', '&#xD;&#xA;', true(), true(), true() )</code>


Returns two items, without the last parameter for ‘Separator is a string’ there would be **six** items:
<code>SplitToArray( 'Z1, Z2, Z1, Z1, Z1, Z1', 'Z2', true(), true(), true() )</code>





**Separation by character** 

Following returns five structure entries with index 0 - 4 and the values.
<code>SplitToArray("Paul;Mustermann;street 22;99999,city", ";,")</code>

The next one results in value: "street 22"
<code>SplitToArray("Paul;Mustermann;Street 22;99999,City", ";,")/Items[@Index = 2]/@Value</code>

Without specification of the third parameter, empty values are removed, so the next statement returns the value: "99999".
<code>SplitToArray("Paul;; Street 22,,;99999,City", ";,")/Items[@Index = 2]/@Value</code>

The following delivers: 4
<code>count(SplitToArray("Paul;; Street 22,,;99999,City", ";,")/Items) </code>

Without removing blank values and without trim, by setting parameters three and four to false, the next example returns the value: " Street 22".
<code>SplitToArray("Paul;; Street 22,,;99999,City", ";,", false, false)/Items[@Index = 2]/@Value</code>

**Use a string as a separator:** @Rg_Betreff = "Test Erechnung&#xD;&#xA;Zeile 2"
<code>SplitToArray( @Rg_Subject, '&#xD;&#xA;', true(), true() )</code>

{{:images:sign_warning.png?nolink|}} Note: [[en:howtos:buildhierarchwithsplittoarray|]]