Normalising values

[#1]

Hi guys

I have a field called 'Distributor'. I need to roll up the following values within that field so that i.e. 'Gerrys Curtains Ltd', 'Gerrys Curtains Group', 'Gerrys Curtains GMBH' and 'Gerrys Curtains Plc' all roll up into 'Gerrys Curtains Plc'.

Thanks

Sid.

[prieper]

Have you tried with the MAPPING-function?

mapDistributor:

MAPPING LOAD * INLINE [read, show

Gerrys Curtains Ltd,Gerrys Curtains Plc

Gerrys Curtains Group,Gerrys Curtains Plc

Gerrys Curtains GMBH,Gerrys Curtains Plc

Gerrys Curtains Plc,Gerrys Curtains Plc];

MAP Distributor USING mapDistributor;

Table might be created in Excel or the like as well ....

HTH Peter

[maxgro]

load

  Distributor,

  pick(wildmatch(Distributor, 'Gerrys Curtains*', '*'), 'Gerrys Curtains Plc', Distributor) as NewDisstributor;

  .......

from

......