removing characters

elvis_impersonating_penguin · February 27, 2001

how can i make a calculation field that takes the value of another field and removes all characters that are not either a letter or a number.

Vaughan · February 27, 2001

Use nested Substitute() functions, one for each character you want to remove.

It's going to be ugly though...

elvis_impersonating_penguin · February 28, 2001

how would i go about nesting them???

i think that i can get away with only have 2 characters that have to be removed..

[This message has been edited by bman (edited February 28, 2001).]

elvis_impersonating_penguin · February 28, 2001

ok i figured it out... i had to make a couple different fields and things like that.. but i got all the characters removed that i needed to remove..

Recommended Posts