IP Address = Subnet Mask Calculation
Does anyone have a way to take a field that contains a ip address and from that ip address calculate the subnet that ip belongs too? There are thousands of calculators out there but I want to be able to create the calculation in Archer.
Any ideas, suggestions?
You could use calculated fields to do the calculations, converting IPs to decimal then back to IPs. We do this to find the start and end IPs for CIDR notation, and have more off-layout fields for calculations (using LEFT, FIND, SUBSTRING, LEN functions mostly to get to decimal, and CONCATENATE, INT and MOD to get back to IP format)