Remove - and Blank space

[sona_sa]

Hi Team,

I want to remove - in my table and also if there is LAB KPI is there, I need that should to display LABKPI.

		VERIFICATION AREA
		Area1
		area51
		Certification
		CMCC_Specific
		CNT
		CPD-CT
		CPD-DT
		CT-PS
		CT-RF
		CTPS
		CTRF
		DT
		DTNew Features_INTERNAL
		eNB
		Field Test
		FRT
		FT
		HWMM
		ICT
		IODT
		iVP
		LAB-KPI
		Lab Infra
		Lab KPI
		LabKPI Infra
		LabKPI Simulator
		MFT
		Modem Legacy Features
		NV-IOT
		NV-IOT-FDD
		NV-IOT-TDD
		NV-IOT-TDS
		NV-IOT_In-House
		NVIOT
		OP-IOT
		PS-FW SubSystem
		PSSI_Lab
		QVDev
		Release Test
		RF KPI
		Simulation
		Stability
		System KPI
		System Test
		System Verification
		System_Regression
		TDSRMM
		Training

[ujjwalraja]

PurgeMap:
MAPPING LOAD * INLINE [

char replace
-
_

] (delimiter is ‘ ‘)
;

[Verification Area]:

Load

MapSubString(‘PurgeMap’, [Field Name]) as [New Field Name];

Load * inline

[

Field Name

]

;

[tresB]

Have you tried PurgeChar()

Purgechar([Verification Area], '- ')