| 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 1
In the demo.ecommerce.data table, we want to transform the numbers in the bytesTransferred column into string format. To do it, click Create column and select the To string operation. The arguments needed are:
...
str(field)str(json_string)
Example 1
You can copy the following LINQ script and try the first example explained above on the demo.ecommerce.data table.
| Code Block |
|---|
from demo.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.data
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 |