Skip to main content Skip to complementary content
Close announcements banner

SubstringBefore

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

Information noteNote: This feature is available only if you have installed the R2022-12 Talend Studio monthly update or a later one delivered by Talend. For more information, check with your administrator.

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 – let us know how we can improve!