How do I delete all content except certain string

[gyagos]

Ive been searching thru the forums and cannot find the answer im looking for. I have a spreadsheet with 2440 rows and im looking to get the following string placed in a different column. Anyhting that starts with cpe:/a:apache:http_server to be exact as there are multiple versions in the spreadsheet and some cels might have 2 entries for 2 different versions
cpe:/a:apache:http_server:2.4.39

The cel in its entirety looks like the following:

"cpe:/a:gnupg:libgcrypt:1.5.3","cpe:/a:ibm:global_security_kit:8.0.50.66","cpe:/a:ibm:tivoli_storage_manager_client:7.1.6.5","cpe:/apenbsdpenssh:7.4","cpe:/a:apache:log4j:1.2.17","cpe:/a:splunk:splunk:8.2.3","cpe:/a:tenable:nessus_agent:10.1.3","cpe:/a:apache:http_server:2.4.6","cpe:/a:apache:log4j:2.17.1","cpe:/a:docker:docker:1.13.1","cpe:/a:fasterxml:jackson-databind:2.12.1","cpe:/a:fasterxml:jackson-databind:2.9.8","cpe:/araclepenjdk:1.8.0.161.14","cpe:/araclepenjdk:1.8.0.312.07","cpe:/aivotal_software:spring_framework:5.0.10","cpe:/a:apache:log4j:2.17.2","cpe:/a:apacheoi:3.17","cpe:/a:apache:struts:1.3.8","cpe:/a:apache:tomcat:8.5.78","cpe:/a:fasterxml:jackson-databind:2.9.7","cpe:/aivotal_software:spring_framework:4.3.14","cpe:/a:jquery:jquery:1.11.3","cpe:/a:nginx:nginx:1.8.0","cpe:/a:gitlab:gitlab:13.11.3","cpe:/a:gnupg:libgcrypt:1.8.6","cpe:/a:nginx:nginx:1.18.0","cpe:/aracle:jre:1.11.0.13.8-lts" Thank you in advance

 

[gyagos]

Thank you for this.
i just moved data around and it's exactly what i needed. Its a great help

 

[Fluff]

You're welcome & thanks for the feedback.

Please update your profile as requested, so members don't have to ask you every time.