Hear from Salesforce leaders on how to create and deploy Agentforce agents.
Contact Us 1-800-596-4880

substringBeforeLast

substringBeforeLast(text: String, separator: String): String

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

Introduced in DataWeave version 2.2.0.

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", "")
}
DataWeave

Output

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

substringBeforeLast(text: Null, separator: String): Null

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

Introduced in DataWeave version 2.2.0.