Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to delete any thing start with 'DUM'
I try this expression but it doesn't work !
=if(left ([P_PO Number]) = 'DUM', PurgeChar([P_PO Number],''))
Hi Mohammed,
Try,
=if(Left ([P_PO Number],3) <> 'DUM', [P_PO Number])
Try: if(left([P_PO Number], 3) <> 'DUM', [P_PO Number])
- Marcus
try this
=if(not wildmatch(lower(trim([P_PO Number])),'dum*'),[P_PO Number]) as [P_PO Number]
Hi,
One more solution
try with match() or wildmatch()
like
if(not wildmatch([P_PO Number],'DUM*'),[P_PO Number])
or
if(not match([P_PO Number],'DUM*'),[P_PO Number])
Regards