Simplicty and flexibility!


New Function in 8 - StringBetween() - Cut out the string between to search values. (Ver. 8.0.0.1201)

Started by DataEase
You will need to Sign In to be able to comment on the Blog!

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




Written by DataEase 16/01/13 at 14:32:16 Dataease [{8}]FIVE