| Table of Contents | ||||
|---|---|---|---|---|
|
...
How does it work in the search window?
Select Create column field in the search window toolbar, then select the Replace first operation. You need to specify three arguments:
Argument | Data type |
|---|---|
Starting string mandatory | string |
Substring to search mandatory | string |
Substring to replace mandatory | string |
The data type of the values in the new column field is string.
Example
In the demo.ecommerce.data table, we want to create a new column field that replaces only the first = occurrence in all the strings of the uri column by _ . To do it, we will create a new column field using the Replace first operation.
The arguments needed to create the new column field are:
String - uri column field
Substring to search - Click the pencil icon and enter =
Substring to replace - Click the pencil icon and enter _
...
Click Create columnfield and you will see the following result:
...
replace(string, string_to_search, string_to_replace)
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 replace(uri, "=", "_") as `first=by_` |