Table of Contents | ||||
---|---|---|---|---|
|
...
How does it work in the search window?
Select Create column in the search window toolbar, then select the Template operation. You need to specify one argument:
Argument | Data type |
---|---|
Reputation mandatory | string |
The data type of the values in the new column is template.
Example
In the demosiem.logtrust.ecommerceweb.dataactivity
table, we want to create a column that shows the character - in template data type so we can use it later as an argument of another operation. To do it, we will create a new column using the Template operation. Let's call it templates.
...
A column in template data type that contains a hyphen and can be used in other operations, such as Substitute (subs) and Substitute all (subsall) operations.
...
We can also create a column in the demo.ecommerce.data
table that shows the character - after the first capturing group, in template data type so we can use it later as an argument of another operation. To do it, we will create a new column using the Template operation. Let's call it templatesCaptGroup.
The arguments needed to create the new column are:
...
Use the operator select
... as
... and add the operation syntax to create the new column. This is the syntax for the Template operation:
template(string)
Example
You can copy the following LINQ script and try the previous examples on the demosiem.logtrust.ecommerceweb.dataactivity
table.
Code Block |
---|
from demosiem.logtrust.ecommerceweb.dataactivity select template("-") as templates |
Code Block |
---|
from demosiem.logtrust.ecommerceweb.dataactivity select template("\\1-") as templatesCaptGroup |