Custom Function Request: different version of the MID function
Though I can understand why it is the way it is, I have never cared for Excel's MID function. It can be lengthy and seems unnecessarily complicated for some scenarios. I would love it if MV could make a similar custom function (I will call it BETWEEN here) that returns a part of a string that is found between a beginning character & end character.
Excel's function is:
MID(string,position1,position2)
-----typically means using other parsing functions like FIND to position of 2 characters in the string
A more complex version:
BETWEEN(string,character1,instance1,character2,instance2)
-----user would say which instance of the character it was meant to be concerned with
Excel's function is:
MID(string,position1,position2)
-----typically means using other parsing functions like FIND to position of 2 characters in the string
Instead, I would prefer:
BETWEEN(string,character1,character2)-----user would not have to know the position of the charactersI could see that there would be concerns about the same characters appearing more than once in a string. It could either always reference only the 1st instance of each, or the 1st instance of char1 and the last of char2, or add more inputs to determine which one to reference.
A more complex version:
BETWEEN(string,character1,instance1,character2,instance2)
-----user would say which instance of the character it was meant to be concerned with
Depending on the scenario you are using this in, either MID or BETWEEN could potentially end up being faster, but it would be very helpful to have the option of either.
Topic Participants
Sara Johnson
MVU eLearning
Are You Ready to Streamline the Way You Learn?
Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.
Follow us on: