Replace funcion (1 Viewer)

[access09]

How can i use the replace function to replace a number of characters...below is what i have so far:

Expr1: Replace([occupation2],".","")

Above just replace '.' but i want to replace other characters like "`" , "^", "+", and so on.

Does anyone have any ideas??

 

[Atomic Shrimp]

If you just want to remove said characters from the string, you could use my 'allowonly' function

 

[DALeffler]

You can also nest 'em:

x = "A.A'A^A+"
?replace(replace(replace(replace(x,".",""),"'",""),"^",""),"+","")
AAAA

hth,