Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Thank You so much , Manish...You just solve my problem.
Rgds.