To split a string into an array by using a regular expression
This function will split a string into single components using a regular expression. These components are assembled into an array.
The function requires a regular expression, which defines all possible separators. The separators won’t be included in the string array.
Using regular expressions might need some extra research. We recommend checking regular expressions on https://regex101.com/ (external link).
The function can for example help you to process imported data, which contains different information bits in a text field, for example, an address.
If you know the order of your data, you can use
itemto access each element within the generated array again individually.
Result: 666,1234,55,999 (all non-numeric characters are separators)