Substring Before

Substring Before

Returns all the characters from a literal string or the field that you map to this output field that occur before the first substring found that matches the string or character that you specify. If no matching substring is found, this returns an empty string.

Enter a literal value in the String Fragment of property. Or click

to open the Path Selector and map this property to an input field or any text field in block results in this mashup.

Enter a single literal character to search for in the Before String field. You can also click

to open the Path Selector and map this property to a numeric field to supply this value.