to_float - Learn more about the Cortex Query Language to_float() function that converts a string to a floating point number. - Administrator Guide - Cortex XSIAM - Cortex - Security Operations

to_float(<string>)

The to_float() function converts a string that represents a number to a floating point number. This function is identical to the to_number function.

Display the first 10 IP addresses that begin with a value greater than 192. Use the split function to split the IP address by '.', and then use the arrayindex function to retrieve the first value in the resulting array. Convert this to a number and perform an arithmetic compare to arrive at a result set.

dataset = xdr_data 
| fields action_local_ip  as alii 
| filter to_float(arrayindex(split(alii, "."),0))  > 192 
| limit 10