Edit

Share via

format_ipv4()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Parses the input with a netmask and returns a string representing the IPv4 address.

Syntax

format_ipv4(ip [, prefix])

Learn more about syntax conventions.

Parameters

Name Type Required Description
ip string ✔️ The IPv4 address. The format may be a string or number representation in big-endian order.
prefix int An integer from 0 to 32 representing the number of most-significant bits that are taken into account. If unspecified, all 32 bit-masks are used.

Returns

If conversion is successful, the result will be a string representing IPv4 address. If conversion isn't successful, the result will be an empty string.

Examples

The following example shows how to use the format_ipv4() function to parse the input with a netmask and return a string representing the IPv4 address.

:::moniker range="azure-data-explorer"
> [!div class="nextstepaction"]
> <a href="https://dataexplorer.azure.com/clusters/help/databases/Samples?query=H4sIAAAAAAAAA0tJLAHCpJxUjcSUlKLU4mKr4pKizLx0HYXcxOJsq5z8vHRNrmguBXVDSyM9QzMLPUM9Q3UdBSMTHQU4wJA1NsIpq29kgqIAmyzIUg1dQ00dBa5YrhqF1IqS1LwUBaDjSnNKFGwV0vKLchNL4jMLykxgjoa4FqQBbi1EeTxIHFUPWAhNIwAom5ZMBgEAAA==" target="_blank">Run the query</a>
::: moniker-end

```kusto
datatable(address:string, mask:long)
[
 '192.168.1.1', 24,          
 '192.168.1.1', 32,          
 '192.168.1.1/24', 32,       
 '192.168.1.1/24', long(-1), 
]
| extend result = format_ipv4(address, mask), 
         result_mask = format_ipv4_mask(address, mask)

Output

address mask result result_mask
192.168.1.1 24 192.168.1.0 192.168.1.0/24
192.168.1.1 32 192.168.1.1 192.168.1.1/32
192.168.1.1/24 32 192.168.1.0 192.168.1.0/24
192.168.1.1/24 -1

Related content