Separate Values

[darren_dixon]

Hi,

I have a field which contains one or more names and was wondering how I could separate them.

My list box looks like this:

Field: mrASSIGNEES

Andrew

Andrew Ian

Andrew Jon Ian Gary

I'd like my list box to look like this:

Andrew

Gary

Ian

Jon

Thanks,

Darren

[tresB · Accepted solution]

Try SubField() function like:

Subfield(mrASSIGNEES, ' ')

Update: PFA

[dmohanty]

Hi,

Tresco's solution is very simple and good.

To understand the functionality of Subfield and other functions, you can use this code as well. This wont have the repetive values in the new field.

Name:

load * Inline
[

Name
Andrew
Andrew Ian
Andrew Jon Ian Gary

];

Name1:
load
*,
SubField(Name, ' ',1) as N1,
SubField(Name, ' ',2) as N2,
SubField(Name, ' ',4) as N3

Resident Name;

drop Table Name;


Newname:

load
N1 as NewName Resident Name1;

Concatenate (Newname)

load
N2 as NewName Resident Name1;

Concatenate (Newname)

load
N3 as NewName Resident Name1;

Regards!!!