Between Start & End Text

Description

Extracts n number of characters starting from a start and end position indicated by a sequence of characters.

When you apply this operation, you are first asked to start string to start extracting from, and then the end string to end the extraction. You can instruct the application to ignore the text of the case by selecting the Ignore Case checkbox.

Use the preview column to help you set the correct Length and Start Position values:

 

Input/Output Data Type

Input

Output

text

text

 

Example

In this example, SALES TERRITORY is the original column. We start extracting after the string / and end on the string / to obtain the column SALES TERRITORYSubstring.

 

 

© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support