Expression Error

[Anonymous]

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],''))

[tamilarasu · Accepted solution]

Hi Mohammed,

Try,

=if(Left ([P_PO Number],3) <> 'DUM', [P_PO Number])

[marcus_sommer]

Try: if(left([P_PO Number], 3) <> 'DUM', [P_PO Number])

- Marcus

[Kushal_Chawda]

try this

=if(not wildmatch(lower(trim([P_PO Number])),'dum*'),[P_PO Number]) as [P_PO Number]

[PrashantSangle]

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