Substituting characters in a field?

[Lange]

Is it possible to create a calculation that will substitute some characters in a field and place the result in another field?

Example: Field 1 contains "larsson"

I would like to change occurences of "a" to "e" and "s" to "t", resulting in field 2= "lertton"

Get the idea?

[-Queue-]

Make the result field a calculation of Substitute( Substitute( Field1; "a"; "e" ); "s"; "t" ), nesting as necessary.

[Lange]

Thanks! it works.

it was the nesting that solved my problem. Now I have a calculation with about 15 Substitute(Substitute(Substitute... - but it works!