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

[ajaykumar1]

Hi,

Whats your expecting output?

Regards,

Ajay

[Anonymous]

names are similar so i want single

output:

Caremark P.R. Specialty Pharmacy

[fvelascog72]

Hi,

Try this:

DATA:

LOAD

  Replace(Name,'  ',' ')

Inline [

Name

Caremark P.R. Specialty Pharmacy

Caremark P.R. Specialty  Pharmacy

];

[antoniotiman]

If Your problem is only 2 spaces instead 1, You can use

Replace([Pharmacy Name],'  ', ' ')             ('2 spaces','1 space')

Regards,

Antonio

[ajaykumar1]

Try this;

But not sure

=if([Pharmacy name]='Caremark P.R. Specialty  Pharmacy',(replace([Pharmacy name],'Caremark P.R. Specialty  Pharmacy','Caremark P.R. Specialty  Pharmacy')))

Regarrds,

Ajay

[Anonymous]

but i have 100 pharmacy names with typo errors .

can i use mix match like that

thanks

[tamilarasu]

Hi,

Try like below,

Table1:
LOAD  Replace(Trim([Pharmacy name]),'  ', '') as [Pharmacy name]
FROM
concate.xlsx
(ooxml, embedded labels, table is Sheet1);
concatenate(Table1)

LOAD  Replace(Trim([Pharmacy name]),'  ', '') as [Pharmacy name]
FROM
concate.xlsx
(ooxml, embedded labels, table is Sheet2);

[jagan]

Hi,

Use this script

Table1:

LOAD [Pharmacy name],

Replace([Pharmacy name], '  ', ' ') AS  Pharmacy_Name_Formatted

FROM

concate.xlsx

(ooxml, embedded labels, table is Sheet1);

concatenate(Table1)

LOAD [Pharmacy name],

Replace([Pharmacy name], '  ', ' ') AS  Pharmacy_Name_Formatted

FROM

concate.xlsx

(ooxml, embedded labels, table is Sheet2);

Regards,

Jagan.

[Anonymous]

hi all,

Thanks for your valuable time

i have like

TOPS - Texas Oncology Pharmacy Services

TOPS Texas Oncology Pharmacy Services

like this i have 10 to 15 names with Minor changes .

is there any dynamic way to solve

this problem