remove last part of an ip-adress

[chvizda]

Hi all

I hope you can help me out with following. I have IP adresses:

172.12.115.13

and I want to remove the last digits to have only

172.12.115.

The adress can be in any other format

10.10.10.10

1.1.1.1

192.168.150.1

...

Many thanks in advance

Steffen

[patrick_digan · Accepted solution]

@chvizda I would use a regular expression like:

REGEX_Replace([Field1], "(.*)\..*","$1.")

I've attached a quick version 11.0 sample

[chvizda]

works perfect. many thx

[MarqueeCrew]

Hold the presses @chvizda!  

I agree that @patrick_digan gave you a great solution.  If you like RegEx that is.  Did you know that RegEx is an expensive operation?  The timing for 10,000,000 records took me almost 20 seconds to process.  I used a non-RegEx solution and got to the same results in 8 seconds.

Left([field1],Length([field1])-(FindString(ReverseString([Field1]), ".")+1))

Granted, my formula is odd but here's a quick explanation.

• Reverse the IP Address
• Find the first (last) '.'
• Add 1 (this is zero-based) to that location
• Take the left-most characters from the input minus the total number of characters to that last '.'

Cheers,

Mark

[patrick_digan]

@MarqueeCrew I know some folks may not like it, but I truly love when the ReverseString formula can be used. I like your solution!