Filter mulitple words in same filed

[darren]

Hi,

I am using a script to find a series of records. Each record is in a particular sector ie

Supermarket

Furniture Retail

Fashion

Field Sales

As the script runs through the records it 'inserts a calculated result' into a global field.

My Problem is that I only want the sector to appear once, so if there are three records with the same sector then only 1 instance of the word should appear.

can anyone help me with a solution?

Thanks

Darre

[LaRetta]

Hi Darre,

Try this ...

Go To Record/Request/Page [ First ]

Loop

If [ not Position ( global, textfield, global, 1)

Set Field [ global, If(IsEmpty(global), textfield, global & "

[LaRetta]

There is a quicker way if you want ALL values from that field (and not only those contained in the found set) which will also put them in alpha order for you.

If you create a Value List out of that textfield (using all values from field), then create a calculation (text, unstored) with:

ValueListItems(Status(CurrentFileName); "New Value List")

Then a simple step, without running through the records would be:

Set Field [ global, NewCalcField ]

It doesn't matter which record you are on when you fire this script because the calculation would display the same for all records. I corrected the above two posts; I had put ';' in syntax instead of ',' as required for pre-7 versions.

LaRetta