text of … between … and … extracts that part of a ‘string’ of text between two numeric bounds which represent the position of the start and end characters to be included. (In programming parlance, this is called a ‘substring’.) For example, given the following case fragment:
01 Jun 03 20 Jun 03 01 Jul 03 23 Aug 03 02 Nov 03 Test1 1234567 1234567 1234567 1234567 7654321 Test2 abc abcd bcde Test3 diabetic diabetic diabetic
then the following conditions are true:
text of Test1 between 1 and 4 is “7654”
text of Test2 between 2 and 3 is “cd”
text of most recent Test3 between 1 and 4 is “diab”
See also:
Extracting numbers from textual data.
Text between
Text after
Text before