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
Solved! Go to Solution.
@chvizda I would use a regular expression like:
REGEX_Replace([Field1], "(.*)\..*","$1.")
I've attached a quick version 11.0 sample
works perfect. many thx
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.
Cheers,
Mark
@MarqueeCrew I know some folks may not like it, but I truly love when the ReverseString formula can be used. I like your solution!