Views:

Product: LABEL MATRIX

Version: All Versions

 

StrBefore(data,start before, length):   This function results in a string that is exactly length characters long before a specified start before character.

Expression

Result

StrBefore("1234-5678", "-", 2)

Takes the 2 characters immediately before the dash  (34)

StrBefore("1234-5678", "-")

Takes all characters before the dash  (1234)