| Table of Contents | ||||
|---|---|---|---|---|
|
...
Converts an integer, float, timestamp, ip, geocoord or mac type value into string data type.
You can also extract a string value from a json (json data type) using the Jq evaluation (jqeval) operation and convert it into string type.
How does it work in the search window?
Select Create column in the search window toolbar, then select the To string operation. You need to specify one argument:
Argument | Data type |
|---|---|
Date / Number mandatory | integer, float, timestamp, ip, geocoord, mac, json |
The data type of the values in the new column is string.
| Note |
|---|
When using the search window interface to manually introduce the content of the argument, it will be automatically converted into the data type that matches the format before actually converting it into string data type. However, you will not notice that such an intermediate step exists. For example, if you introduce coordinates, they will be automatically transformed in the background into geocoord data type and then into string. Though most of these conversions are implicit while using the search window interface, they must be explicitly done when writing the query in LINQ. For example:
|
Example
...
Number - bytesTransferred column
...
Click Create column and you will see the following result:
...
Example 2
We have the following JSON string:
...
We use the To json (jsonparse) operation and enter the JSON string we want to use to get a column representing it in json data type.
...
Step 2: Extract the string value from the JSON objects
...
jq - Click the pencil icon and enter .str
json - json column
...
Step 3: Transform the string values into string data type
...
str(field)str(json_string)
Example
...
You can copy the following LINQ script and try the first second example explained above on the demosiem.logtrust.ecommerceweb.dataactivity table.
| Code Block |
|---|
from demosiem.ecommerce.data select str(bytesTransferred) as BytesString |
Example 2
You can copy the following LINQ script and try the second example explained above on the demo.ecommerce.data table.
| Code Block |
|---|
from demo.ecommerce.datalogtrust.web.activity select jsonparse("{\"str\": \"hello\", \"int\": 1, \"float\": 2.5, \"boolean\": true, \"array\": [1,2,3], \"object\": {\"a\": 5}}") as json select jqeval(jqcompile(".str"), json) as jsonString, str(jsonString) as String |