Hi,

Can anyone direct me how to trim this value:

Example:
ip address: 199.171.216.254:22808 to 199.171.216.254

I have above 10,000 record if IP addresses and I need to remove all numbers after (, including (

Thank you

Roman