concatenate Pharmacy names ,space creating problem

[Anonymous]

hi gurus,

i have pharmacy name:

Caremark P.R. Specialty Pharmacy

Caremark P.R. Specialty  Pharmacy

i want to concatenate into single name,but there is space difference between two pharmacy names

plz find the sample application

[fvelascog72]

Hi,

Try this:

Replace(PurgeChar(Name,'-'),'  ',' ')

[jagan]

Hi,

For this type of scenarios you have to maintain a mapping file like below

PharmacyName, PharmacyNameGroup

TOPS - Texas Oncology Pharmacy Services, TOPS - Texas Oncology Pharmacy Services

TOPS Texas Oncology Pharmacy Services, TOPS - Texas Oncology Pharmacy Services

Caremark P.R. Specialty Pharmacy, Caremark P.R. Specialty Pharmacy

Caremark P.R. Specialty  Pharmacy,Caremark P.R. Specialty Pharmacy

Now you can use PharmacyNameGroup in the list box.  Otherwise it is very difficult to handle.

Regards,

Jagan.