Splitting Names 1

[edmac2]

Crystal 6
I have a field that consists of names as McCormick Ed. How would I be able to make this into 2 fields say FirstName, LastName.Each Name has a space between first and last name or just be able to split it up so I could get the first name or the last name in another field.

 

[kenhamady]

Look up the InStr function in CR help. This will calc the numeric position of the space.

Then use this number to SubString the field into two fields.

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[edmac2]

Got it Thanks