substringBefore
Returns the portion of a String value that occurs before the first occurrence of some other value.
| RecordPath | Return value | 
| 
                         | John | 
| 
                         | J | 
| 
                         | John Doe | 
| 
                         | John Doe | 

