regexpSplitParts - Split and capture a token in one command

We often split string values in order to capture some consistent parts. For example, we split chris@coralogix.com on @ to capture the domain, coralogix.com. regexpSplitParts does two things in one. The first is it splits a string on some delimiter regular expression. The second is it returns the Nth token.

Note

index counts from 1, not from 0.

Syntax

Like many functions in DataPrime, regexpSplitParts supports two notations, function and method notation. These interchangeable forms allow flexibility in how you structure expressions.

Function notation

regexpSplitParts(string: string, delimiter: regexp, index: number): string

Method notation

string: string.regexpSplitParts(delimiter: regexp, index: number): string

Arguments

Name	Type	Required	Description
string	string	true	The string to split
delimiter	regexp	true	The regex delimiter on which to split the string
index	number	true	The index of the desired split strings.

Example - Capturing values from inconsistent data

Consider the following document:

{
    "values": "val=4 val2=8  val3=9   val4=10"
}

Extracting a key-value pair from this document will be challenging, because they are all separated by a varying number of spaces. regexpSplitParts can handle this. I can use regexpSplitParts to split the values based on 1 or more ' ' characters, and then grab the value that I want.

Function notation

create val from regexpSplitParts(values, /\s+/, 3)

Method notation

create val from values.regexpSplitParts(/\s+/, 3)

This results in the following document:

{
    "email": "chris@coralogix.com",
    "val": "val3=9"
}

Try it yourself

Open up your log explore screen and run the following command:

create values from 'val=4 val2=8  val3=9   val4=10'
| create val from values.regexpSplitParts(/\s+/, 3)

padRight

Next rtrim