Ricardo Posted October 11, 2002 Posted October 11, 2002 Hi All, I want to write a script where when the script is activated it will move 1 up the alphabet e.g Version field = A (run script) then version = B. i know i could do it using an 'if' statement where if version = A insert B or if version = R insert S. but is there a better way? hope i gave explained this ok!!!
CobaltSky Posted October 11, 2002 Posted October 11, 2002 Try using a single script step, as follows: Set Field ["VersionField", "Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ", Position("ABCDEFGHIJKLMNOPQRSTUVWXYZ", VersionField, 1, 1) + 1, 1)"] If VersionField is empty when the script runs, it will give you 'A'. If VersionField has 'Z' in it, it will be cleared. Otherwise, VersionField will be incremented onwards one character through the alphabet each time the script runs.
Recommended Posts
This topic is 8079 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