Addam Posted June 13, 2002 Posted June 13, 2002 ISSUE: My users use abreviations when they type some things in. I figured out how to use the "Substitute" function, but I can't seem to get it to replace more than one at a time example: Field 1: We all say "TGIF" but some say "Agh". What do you say? Field 2: We all say "Thank God it's Friday" but some say "Ahh Go HOME!". What do you say? SETUP: Administrators are able to enter in the acronyms in one field and what it should be in another. FIELD 2 will then search the string and change out all the acronyms and display the correct results... Can anyone help?
BobWeaver Posted June 13, 2002 Posted June 13, 2002 You either have to apply the Substitute function successively, or use nested Substitutes
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now