5 Replies Latest reply on Aug 13, 2018 1:41 AM by Ankit Bansal

    Regex-extract to extract a IP Address from a string

    Gurpreet singh

      Hi All,

       

      I have a column "Description" which will have email ID, alphanumeric text, domain name, IP address etc.

      I want to fetch only IP Address and it is always after word "IP Address:"

      and after IP address's there is in consistent data sometime "Results:" will come, sometimes "vulnerability title", sometimes "vulnerability type".

       

      I want to take out highlighted data(please see below screenshot) from column Description.

       

      I tried it with Contains keyword, Regex extract also but no luck.

      I am not that much expert in Regular expression but i know Regex are more powerful to resolve these kind of issues.

       

      Request you to please help me if you can!

       

       

       

      Thanks

      Gurpreet