How to extract text prior to special character "/"

[#1]

I am trying to extract text appearing before "/".  In this case, the cell content that I want to extract is a name in the form "Last, First".

[sunny_talwar]

May be like this

SubField(FieldName, '/', 1) as [First & Last Name]

This assumes that there will not be a / in the first and last name part of the string

[#3]

Thanks for the reply, Sunny.  To clarify the data layout:  SILVA, MARK/.  My goal is to extract SILVA, MARK....and disregard all characters after "/".

[sunny_talwar]

That's what the above should do... is it not doing that?

[#5]

I will try and let you know.  Thanks!

[Peter_Cammaert]

To quickly check out the effectivenes of Sunny's solution, create a text box and enter this formula:

=Subfield('SILVA, MARK/WAHLBERG JOHHNY', '/', 1)