SPLIT... seems to be simple but do not know how

[simply2703]

Hi all,

I am just a freshman with Crystal Reports 2008. Now I am facing with a problem as following:

I have some name strings - "Vu Thi Mai Hoang", "Nguyen Phuong Loc", etc. I want to retrieve their last names. That means I want to get "Hoang" and "Loc". Here is my demo code:

StringVar myName = "";
numberVar  myCount := 0 ;
StringVar array Regions;
 
Regions := Split("Vu Thi Mai Hoang");
myCount= count(Regions);
myName:= Regions(myCount);
 
formula = myName;

Then I got an error message "The remaining text does not appear to be part of the formula".

Could you give me some suggestion?

Thank you so much!

 

[kevlray]

The Split is fine. But to pull a value from the array, use square brackets (i.e., myName := Regions[myCount]

 

[simply2703]

thanks kevlray