Hanson Posted June 2, 2000 Posted June 2, 2000 Hi I rechive the following error message when i try to specify the following Replace Calculation: Replace(Validation,1,2,1) The number 2 is highlighted. An operator (e.g.+,-,*...) is expected here. Regards Hanson ------------------ HansonTimeSolution Jan Hanson fax. (+45) 44 44 81 07
Louisa Posted June 5, 2000 Posted June 5, 2000 Hi, If you're trying to replace the field Validation by the value 1, then place quotes around the one: Replace(Validation, 1,2,"1") - this replaces the first two characters in the field by 1. You might also have problems because the length of your replacement string is only one character long. Also check that Validation is a text field and contains two characters. Louisa
Recommended Posts
This topic is 9028 days old. Please don't post here. Open a new topic instead.
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