Place everything before --- into a variable

[jasonhuibers]

Charlie/Sam/Mike---Lee/Ho/Chu

How can I take everything before '---' and store into a variable
and everything after '---' into a second variable?

First Name: Charlie/Sam/Mike Last Name: Lee/Ho/Chu

 

[PHV]

A starting point:

yourString="Charlie/Sam/Mike---Lee/Ho/Chu"
FirstName=Left(yourString,InStr(yourString,"---")-1)
LastName=Mid(yourString,InStr(yourString,"---")+3)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[guitarzan]

Another option, assuming there is always a "---" in the string:

yourString="Charlie/Sam/Mike---Lee/Ho/Chu"
arrName = Split(yourString, "---")
FirstName=arrName(0)
LastName=arrName(1)