substringBefore

Returns the portion of a String value that occurs before the first occurrence of some other value.

RecordPath

Return value

substringBefore( /name, ' ' )

John

substringBefore( /name, 'o' )

J

substringBefore( /name, '' )

John Doe

substringBefore( /name, 'xyz' )

John Doe