Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
Num(Replace(code_nr, 'PBR', '00'), '##')
Num#(Replace(code_nr, 'PBR', '00'), '##')
May be this:
Num(Replace(code_nr, 'PBR', '00'), '##')
Num#(Replace(code_nr, 'PBR', '00'), '##')
Try like:
Replace([code_nr],'PRB','00')
Another way
00 & purgechar([code_nr],'PRB')
This function change my field but add 00 before every occurrency in my dimension
Tks!!
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
Then I would use WildMatch()
If(WildMatch(code_nr, 'PBR*'), '00', code_nr)