topic Need Help in Remove Function in QlikView

Need Help in Remove Function

Anonymous — Thu, 17 Apr 2014 21:43:27 GMT

Hello! I need help to compose a formula to ommit a a ceratin characters (-T,-DM,DM,-P*)...

Material Desire Results

15-9350-01-T 15-9350-01

201111111DM 201111111

201212121-DM 201212121

SA20111-PST SA20111

15-93520-01-PSW 15-93520-01

Pls. help...I've been stuck for hours solving this.

Tks.

MK_QSL — Thu, 17 Apr 2014 21:51:28 GMT

Instead of Material use below in your script or UI side...

IF(Index(Material,'-P'),Left(Material,Index(Material,'-P')-1),Replace(Replace(Replace(Material,'-T',''),'-DM',''),'DM','')) as Material

Anonymous — Thu, 17 Apr 2014 22:03:55 GMT

Thank You so much , Manish...You just solve my problem.

Rgds.