Page Comparison

...

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:

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. 

from demosiem.logtrust.ecommerceweb.dataactivity
  select template("-") as templates

from demosiem.logtrust.ecommerceweb.dataactivity
  select template("\\1-") as templatesCaptGroup