This takes in the source text and trim the source text about the defined substring.

Section Text Setup

Name Description
Source This is the input text.
Substring This is the substring input.
Include Substring Include/Exclude the substring into the result.
Ignore Case Define if the substring should be case sensitive or not.
Result This is the output result.
Mode
  • From first Occurrence
  • From last Occurrence
  • up to first Occurrence
  • up to last Occurrence

Example “From first Occurrence”

In this example is the input “Data/Content/SP”.
The substring “/” will be used to seperate the input string.

Everthing behind the first “/” will be used.
The result is “Content/SP”.

Example “From last Occurrence”

In this example is the input “Data/Content/SP”.
The substring “/” will be used to seperate the input string.

Everthing behind the last “/” will be used.
The result is “SP”.

Example “Up to first Occurrence”

In this example is the input “Data/Content/SP”.
The substring “/” will be used to seperate the input string.

Everthing before the first “/” will be used.
The result is “SP”.

Example “Up to last Occurrence”

In this example is the input “Data/Content/SP”.
The substring “/” will be used to seperate the input string.

Everthing before the last “/” will be used.
The result is “Data/Content”.