Enhance SWQL to include PAD for text manipulation
PAD([LEADING|TRAILING|BOTH] ARG [WITH CHARACTER] [TO LENGTH])
Example:
SELECT N.IPAddress AS IP
, N.DnsBackward
, PAD(LEADING ARRAYVALUEAT(SPLITSTRINGTOARRAY(REPLACE(IP,'.','|§|§|')),0) WITH '0' TO 3) AS O1
, PAD(LEADING ARRAYVALUEAT(SPLITSTRINGTOARRAY(REPLACE(IP,'.','|§|§|')),1) WITH '0' TO 3) AS O2
, PAD(LEADING ARRAYVALUEAT(SPLITSTRINGTOARRAY(REPLACE(IP,'.','|§|§|')),2) WITH '0' TO 3) AS O3
, PAD(LEADING ARRAYVALUEAT(SPLITSTRINGTOARRAY(REPLACE(IP,'.','|§|§|')),3) WITH '0' TO 3) AS O4
FROM IPAM.IPNode AS N
WHERE IP IS NOT NULL
ORDER BY O1, O2, O3, O4;
More string parsing is needed in general:
