New Function in 8 - StringBetween() - Cut out the string between to search values. (Ver. 8.0.0.1201)
This function is the last of a triumvirate consisting of StringTo(), StringFrom() and now StringBetween().
Between them they will be able to chop up any string exactly like you want it.
StringBetween is like and XOR of the two other ones i.e if you use the same search criteria as for StringTo() and StringFrom() you will get everything that they aren't interested in ;-) minus the search criteria itself.
StringTo() is kind of logical. It searches from the beginning of a string until it match the criteria and return with the string up to it.
StringFrom() is the same but from the end. i.e.it looks for the last occurrence of the criteria in the string and then return everything AFTER that.
StringBetween() do the same from both ends, but it returns everything then between the criteria.
Ex. we have a string called STRING like this: STRINGTO[STRINGBETWEEN1[STRINGBETWEEN2]STRINGBETWEEN3]STRINGFROM
StringTo(String,"[") will return: STRINGTO
StringFrom(String"]" will return: STRINGFROM
StringBetween(String,"[","]") will return: STRINGBETWEEN1[STRINGBETWEEN2]STRINGBETWEEN3