Substitute

[asgweb]

Hello and thanks in advance. I have a field (PurchaseMinimum)and I want to change the numbers to letters for security purposes. I have this code but I get an error that says I have too many separators... Any help is appreciated.

Substitute (PurchaseMinimum,1,"L",

PurchaseMinimum,2,"U",

PurchaseMinimum,3,"B",

PurchaseMinimum,4,"R",

PurchaseMinimum,5,"I",

PurchaseMinimum,6,"C",

PurchaseMinimum,7,"A",

PurchaseMinimum,8,"N",

PurchaseMinimum,9,"T",

PurchaseMinimum,0,"S"

)

[Lee Smith]

In version 4 you have to gang the Substitutes like this.

Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute(PurchaseMinimum,1,"L"),

2,"U"),

3,"B"),

4,"R"),

5,"I"),

6,"C"),

7,"A"),

8,"N"),

9,"T"),

0,"S"

)