| Table of Contents | ||||
|---|---|---|---|---|
|
...
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 |
|---|---|---|
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 We will create a new column using the Substring operationoperation to do . 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
...
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.
| Code Block |
|---|
from demo.ecommerce.data select substring(timestamp, 3, 3) as substrings |