Wildmatch function in if condition

[canmarroig]

I've to create a list box, changing text into number: if(WildMatch([code_nr],'PRB*'),'00',[code_nr])

i'd like to clean: PRB09090900 into 0009090900. Where's my mistake?

Tks

[sunny_talwar · Accepted solution]

May be this:

Num(Replace(code_nr, 'PBR', '00'), '##')

Num#(Replace(code_nr, 'PBR', '00'), '##')

[tresesco]

Try like:

Replace([code_nr],'PRB','00')

[Kushal_Chawda]

Another way

00 & purgechar([code_nr],'PRB')

[canmarroig]

This function change my field but add 00 before every occurrency in my dimension

[canmarroig]

Tks!!

[canmarroig]

and if I need to change all my string, cointaining a prefix, not only a part of it

PRB09090900

PRB08776766

into 00

Num#(Replace(code_nr, 'PBR*', '00'), '##') is not correct

[sunny_talwar]

Then I would use WildMatch()

If(WildMatch(code_nr, 'PBR*'), '00', code_nr)