Skip to main content Skip to complementary content

SubstringBefore

Returns the part of a string that precedes a given value.

The SubstringBefore function will return the part of the Input Value string that appears before the first occurrence of the substring in Before Value. For example, with the string Hello World in Input Value and l in Before Value, the function returns He.

If the substring in Before Value if not found in the input string, nothing is returned.

Arguments

Input Value Specify the input value to process.

Properties

Before Value Enter a substring of the input value. This value is case-sensitive.

This property is also available as an argument. If you specify both, the argument value is used and the property value is ignored.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!