Any Chance of seeing some fake data in Excel to help you. Fake data Similar to Your actual.
Thanks for looking into immediately!
As requested please have a look into dummy data and keep it in mind that there is always inconsistency in data but IP addresses will be after "IP Address:" only.
Here you go for data:
Request to assess and remediate an identified security issues
Fix Vulnerabilities identified in October2011 for Windows Server Admin - Internal - Confirmed - Critical - EOL/Obsolete Dep: Apache tomcat Server 8.8.x
Details about the Vulnerability Can be found in DM# 2356458983
Vulnerability Title: Dep: Apache tomcat Server 8.8.x
Vulnerability Name : Dep: Apache tomcat Server 8.8.x
Remediation Group : Windows Server Admin 434622
Affected CI : GRSDGP : WIndows Server Admin 555
Thanks Ankit, Much appreciated!
It is returning Null
1) where IP Address has space between "IP Address and colon" for e.g "IP Address :" instead of "IP Address:"
2) where IP Address are in same line for e.g "IP Address: 12.123.342.12" instead of
May i know how to fix it?
Please enlighten me from where i can learn Regex smoothly and effectively.
1 of 1 people found this helpful
This should work for you:
REGEXP_EXTRACT([Description],'(IP Address[ :0-9.]+([\r\n]+[0-9.]+)+)')
I referred to the below article: