Splitting a Field

[scott1971]

Hopefully there's an easy answer to this but I need to split out a Title from the Member name, the title can be various characters obviously but the format is Mr John Smith, Mrs P Smith, Colonel B Mustard etc etc, can anyone tell me a simple way to do this on CR XI?

 

[beltmanjr]

stringVar Array fullString := split('Mr John Smith');

stringVar title := fullString[1];
stringVar firstName := fullString[2];
stringVar lastName := fullString[3];

'Title: ' & title & chr(13) & 'First name: ' & firstName & chr(13) & 'Last name: ' & lastName;

 

[beltmanjr]

The above will give:

Title: Mr
First name: John
Last name: Smith

The string in split('Mr John Smith') is to be replace by your database field.

I guess the line
stringVar title := fullString[1]
is all you'll need.

 

[scott1971]

Thanks for this.