Starting from Left...

Description

Extracts n number of characters from the beginning of a string.

When you apply this operation, you are first asked to enter the number of characters to extract:

 

Use the preview column on the dialog box to determine if you are extracting the correct number of characters.

The dialog box also has a check box that  allows you to remove the original column.

Input/Output Data Type

Input

Output

text

text

 

Example

In this example, License # is the original column. Five characters from the left are extracted to produce the values in License #Left.

 

 

© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support