salesforce Dreamforce On-Demand
Contact Us 1-800-596-4880
  1. Homepage
  2. DataWeave (2.3)
  3. DataWeave Reference
  4. Strings (dw::core::Strings)

  5. substringBeforeLast

substringBeforeLast

substringBeforeLast(String, String): String

Gets the substring before the last occurrence of a separator. The separator is not returned.

Introduced in DataWeave 2.2.0. Supported by Mule 4.2 and later.

Parameters

Name Description

text

The input string.

separator

String to search for.

Example

This example shows how substringBeforeLast behaves with different inputs and sizes.

Source

%dw 2.0
import * from dw::core::Strings
output application/json
---
{
  "a": substringBeforeLast(null, "'"),
  "b": substringBeforeLast("", "-"),
  "c": substringBeforeLast("abc", "b"),
  "d": substringBeforeLast("abcba", "b"),
  "e": substringBeforeLast("abc", "d"),
  "f": substringBeforeLast("abc", "")
}

Output

{
  "a": null,
  "b": "",
  "c": "a",
  "d": "abc",
  "e": "",
  "f": "ab"
}

substringBeforeLast(Null, String): Null

Helper function that enables substringBeforeLast to work with a null value.