Daniel C Posted December 5, 2013 Share Posted December 5, 2013 Hi, I am not sure if this needs to be a custom function or just a calculation but I am trying to increment a field with a letter in it. I have found a function to increment through the alphabet which is what I need but after "Z" I need to go to AA->AB->AC...AZ->BA and so forth. The original topic with the calculation is here: http://fmforums.com/forum/topic/32866-increment-the-alphabet/ Thanks for any help. Daniel Link to comment Share on other sites More sharing options...
comment Posted December 6, 2013 Share Posted December 6, 2013 after "Z" I need to go to AA http://www.briandunning.com/cf/399 Link to comment Share on other sites More sharing options...
Daniel C Posted December 10, 2013 Author Share Posted December 10, 2013 Thanks comment. I don't know how I missed this. I converted my input value to decimal, added 1 and used your custom function. Thanks again. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3791 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