Substring (substring)

[ 1 Description ] [ 2 How does it work in the search window? ] [ 3 How does it work in LINQ? ]

Description

Extracts a substring from a given string, indicating the position starting character. Optionally, you can indicate the length of the substrings. If the length is not specified, you will get all the characters from the starting point indicated.

How does it work in the search window?

Select Create column in the search window toolbar, then select the Substring operation. This operation needs at least two arguments:

Argument	Data type	More information

Argument	Data type	More information
Original string ^mandatory	string
Starting from character ^mandatory	integer	Position of the starting character of the substrings.
Length of substring	integer	The number of characters you want your substrings to have. If not indicated, you will get all the characters from the starting point indicated.

The data type of the values in the new column is string.

Example

In the demo.eccomerce.data table, we want to get only the part indicating the month in our timestamp column. To do it, we will create a new column using the Substring operation. Let's call the new column substrings

The arguments needed to create the new column are:

Original string - timestamp column
Starting from character - 3
Length of substring - 3

Click Create column and you will see the following result:

How does it work in LINQ?

Use the operator select... as... and add the operation syntax to create the new column. These are the valid formats of the Substring operation:

substring(string, starting_position_integer)
substring(string, starting_position_integer, length_integer)

Example

You can copy the following LINQ script and try the above example on the demo.ecommerce.data table.

from demo.ecommerce.data
  select substring(timestamp, 3, 3) as substrings