Need Help in Remove Function

[Anonymous]

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 · Accepted solution]

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]

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

Rgds.