Skip to content

Return Text Between Line Numbers

Return the text between the start and end line number. The text on the start and end lines are both included. For example, if a body of text consists of 5 lines and the start line is 2, and the end line is 4, then the text on lines 2, 3 and 4 is returned. For example:

Return Lines Between Text

The text in the image above, with the function's settings, as demonstrated below, will extract the address details. Depending on your use case, you might want to follow up with a Remove Empty Lines from Text function.

Return Lines Between Text

Example of the Return Lines Between Text function.