How to extract data from a large listbox and place in a new listbox

[sweens78]

Hi Folks,

I've got a list box in which I have a lot of category's in the data so for example I have CHO names, I have 'Hospital Group' names and 'Others'.

At the moment Im just creating Inline map function and writing out the groups as shown below and that creates just a list box with below names.

//CHO Group

LOAD * INLINE [

CHO/HG Link, CHO Link

CHO 1 North West, CHO 1 North West

CHO 2 West, CHO 2 West

CHO 3 Mid West, CHO 3 Mid West

CHO 4 South,CHO 4 South

CHO 5 South East,CHO 5 South East

CHO 6 Dublin SE, CHO 6 Dublin SE

CHO 7 Dublin South, CHO 7 Dublin South

CHO 8 Midlands, CHO 8 Midlands 

CHO 9 Dublin North,CHO 9 Dublin North

];

The problem is it is time consuming and I want to create another list box called 'Others' and just extract that data. 

Is there away of picking my data from the large listbox and extracting this more quickly into aother smaller list box if that makes since!

Thanks a mill

Martin

[jonathandienst]

Do you want to select a subset of the large list box? Have you looked at creating a bookmark?

Or you could enter text like this in the search box to select a bunch of values

('CHO 1 North West'|'CHO 2 West'|'CHO 3 Mid West'|'CHO 4 South')

Or do you want to make it easy for users to select a constant subset? Then use a flag field when loading the field in the large list box to identify the subset members.

[jyothish8807]

May be something like this:

For example if you have all the value under "Field1", then:

A:

Load

if(Wildmatch(Field1,'CHO*'),Field1) as CHO/HG Link,

if(Wildmatch(Field1,'CHO*'),Field1) as CHO Link

resident Table;

B:

Load

if(Wildmatch(Field1,'Other*'),Field1) as Other/HG Link,

if(Wildmatch(Field1,'Other*'),Field1) as OtherLink

resident Table;

[sweens78]

Hi Jonathan, basically I just want to create smaller listboxes with the category's in it, I've achieved this with the mapping inline but I'm typing out everything again from larger listbox.

Its just make it easier for the user to break it down into categorys.