Ok,
I have a field in a database that looks something like this
Field1: BLAHBLAHBLAH (10.192.168.1)
I need to either extract the IP address from this field or at least
format it to only show the IP address in the result. The problem I am
having with my limited experience is that the BLAHBLAH piece can vary
in length and of course the IP piece can vary due to different IP
address sizes. It seems to me there should be some kind of simple
solution since the IP address is enclosed but I cant "enclose" my mind
around what I need to do.
I have a field in a database that looks something like this
Field1: BLAHBLAHBLAH (10.192.168.1)
I need to either extract the IP address from this field or at least
format it to only show the IP address in the result. The problem I am
having with my limited experience is that the BLAHBLAH piece can vary
in length and of course the IP piece can vary due to different IP
address sizes. It seems to me there should be some kind of simple
solution since the IP address is enclosed but I cant "enclose" my mind
around what I need to do.