Extract IP address from a crazy string

[Alteryx_Geek]

Hello Folks,

I am stuck at this issue. I have huge data in spreadsheet, and each row has long crazy string like below and from that I want to extract the ipv4 addresses separately.

Any idea how could I do this ? Also the string is not constant, it keep on changing, the only common thing in the string is it contains ipv4 address

Sgfhgfhg dfgbf fghfghfg 0x2cfjgfj7 A fhfgh-edge-d676d1.pfjfgj1.abs.hls.fjgfj.net  fjfgj fjfgje-edge-efgjfgjnal-pfgjfgjd-73fjfgj60.us-fjfjgst-2.elb.afjfjmfjfjgfjfgjnawfgjs.cofjfgj A 52.11.156.133 A 54.240.138.165 A 52.45.142.156 A 44.249.18.179 A 35.169.132.64 A 46.236.178.15 A 172.148.180.41 A 171.229.78.133 NS ns-332.afjfgjns-4fjfgj1.com gdf ns-56fjfgj0.awfjfgjsdfjfgj-06.net Nfjfgfjfj ns-1769.awfjfjdfjfgj.co.fjfgjfjk Nffjfjfjfj ns-14fjfgjfjg75.awsfjfgjfgjdns-5fjfj.fjfgjorg A 215.251.194.48 A 205.251.198.233 A 245.251.193.76 A 211.251.197.195

[binuacs · Accepted solution]

@Alteryx_Geek 

[Alteryx_Geek]

@binuacs - Thanks, this is helpful