Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Whats your expecting output?
Regards,
Ajay
names are similar so i want single
output:
Caremark P.R. Specialty Pharmacy
Hi,
Try this:
DATA:
LOAD
Replace(Name,' ',' ')
Inline [
Name
Caremark P.R. Specialty Pharmacy
Caremark P.R. Specialty Pharmacy
];
If Your problem is only 2 spaces instead 1, You can use
Replace([Pharmacy Name],' ', ' ') ('2 spaces','1 space')
Regards,
Antonio
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
but i have 100 pharmacy names with typo errors .
can i use mix match like that
thanks
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);
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.
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