Parsing out data from a cel that has multiple entries

[gyagos]

All,
Is there a way to parse out data from a cel and put results into individual cels via VBA code? The actual spreadsheet is 50k rows and this is just a snippet of only one host

First tab (Original) is the original data in the spreadsheet. Column E "pluginText" is the cel that i'm looking to parse
The results i'm looking for are on the results tab

Book1.xlsx
	A	B	C	D	E	F	G
1	HostName	PluginID	CVE	PluginName	pluginText	POC	path
2	he3lxvd601	163304	CVE-2022-21540,CVE-2022-21541,CVE-2022-21549,CVE-2022-25647,CVE-2022-34169	Oracle Java SE Multiple Vulnerabilities (July 2022 CPU)	Path : /auto/he3nas503a39/usr/java/jdk1.8.0_181/ Installed version : 1.8.0_181 Fixed version : Upgrade to version 8.0.341 or greater Path : /auto/he3nas503a39/usr/java/jdk1.8.0_31/ Installed version : 1.8.0_31 Fixed version : Upgrade to version 8.0.341 or greater Path : /fmac/fir/src_repos/jim_testing/gerrit/jdk1.7.0_71/ Installed version : 1.7.0_71 Fixed version : Upgrade to version 7.0.351 or greater Path : /pkgs/JDK/jdk170_55/ Installed version : 1.7.0_55 / build 7.0.55 Fixed version : Upgrade to version 7.0.351 or greater	Application Team-BTO	/auto/he3nas503a39/usr/java/jdk1.8.0_181/
3	he3lxvd601	163304	CVE-2022-21540,CVE-2022-21541,CVE-2022-21549,CVE-2022-25647,CVE-2022-34169	Oracle Java SE Multiple Vulnerabilities (July 2022 CPU)	Path : /auto/he3nas503a39/usr/java/jdk1.8.0_181/ Installed version : 1.8.0_181 Fixed version : Upgrade to version 8.0.341 or greater Path : /auto/he3nas503a39/usr/java/jdk1.8.0_31/ Installed version : 1.8.0_31 Fixed version : Upgrade to version 8.0.341 or greater Path : /fmac/fir/src_repos/jim_testing/gerrit/jdk1.7.0_71/ Installed version : 1.7.0_71 Fixed version : Upgrade to version 7.0.351 or greater Path : /pkgs/JDK/jdk170_55/ Installed version : 1.7.0_55 / build 7.0.55 Fixed version : Upgrade to version 7.0.351 or greater	Application Team-BTO	/auto/he3nas503a39/usr/java/jdk1.8.0_31/
4	he3lxvd601	163304	CVE-2022-21540,CVE-2022-21541,CVE-2022-21549,CVE-2022-25647,CVE-2022-34169	Oracle Java SE Multiple Vulnerabilities (July 2022 CPU)	Path : /auto/he3nas503a39/usr/java/jdk1.8.0_181/ Installed version : 1.8.0_181 Fixed version : Upgrade to version 8.0.341 or greater Path : /auto/he3nas503a39/usr/java/jdk1.8.0_31/ Installed version : 1.8.0_31 Fixed version : Upgrade to version 8.0.341 or greater Path : /fmac/fir/src_repos/jim_testing/gerrit/jdk1.7.0_71/ Installed version : 1.7.0_71 Fixed version : Upgrade to version 7.0.351 or greater Path : /pkgs/JDK/jdk170_55/ Installed version : 1.7.0_55 / build 7.0.55 Fixed version : Upgrade to version 7.0.351 or greater	Application Team-BTO	/fmac/fir/src_repos/jim_testing/gerrit/jdk1.7.0_71/
5	he3lxvd601	163304	CVE-2022-21540,CVE-2022-21541,CVE-2022-21549,CVE-2022-25647,CVE-2022-34169	Oracle Java SE Multiple Vulnerabilities (July 2022 CPU)	Path : /auto/he3nas503a39/usr/java/jdk1.8.0_181/ Installed version : 1.8.0_181 Fixed version : Upgrade to version 8.0.341 or greater Path : /auto/he3nas503a39/usr/java/jdk1.8.0_31/ Installed version : 1.8.0_31 Fixed version : Upgrade to version 8.0.341 or greater Path : /fmac/fir/src_repos/jim_testing/gerrit/jdk1.7.0_71/ Installed version : 1.7.0_71 Fixed version : Upgrade to version 7.0.351 or greater Path : /pkgs/JDK/jdk170_55/ Installed version : 1.7.0_55 / build 7.0.55 Fixed version : Upgrade to version 7.0.351 or greater	Application Team-BTO	/pkgs/JDK/jdk170_55/
Original

Results i am looking for

Book1.xlsx
	A	B	C	D	E	F	G	H
1	Hostname	PluginID	CVE	PluginName	POC	Path	Installed version	Fixed Verion
2	he3lxvd601	163304	CVE-2022-21540,CVE-2022-21541,CVE-2022-21549,CVE-2022-25647,CVE-2022-34169	Oracle Java SE Multiple Vulnerabilities (July 2022 CPU)	Application Team-BTO	/auto/he3nas503a39/usr/java/jdk1.8.0_181/	Installed version : 1.8.0_181	Fixed version : Upgrade to version 8.0.341 or greater
3	he3lxvd601	163304	CVE-2022-21540,CVE-2022-21541,CVE-2022-21549,CVE-2022-25647,CVE-2022-34169	Oracle Java SE Multiple Vulnerabilities (July 2022 CPU)	Application Team-BTO	/auto/he3nas503a39/usr/java/jdk1.8.0_31/	Installed version : 1.8.0_181	Fixed version : Upgrade to version 8.0.341 or greater
4	he3lxvd601	163304	CVE-2022-21540,CVE-2022-21541,CVE-2022-21549,CVE-2022-25647,CVE-2022-34169	Oracle Java SE Multiple Vulnerabilities (July 2022 CPU)	Application Team-BTO	/fmac/fir/src_repos/jim_testing/gerrit/jdk1.7.0_71/	Installed version : 1.8.0_181	Fixed version : Upgrade to version 8.0.341 or greater
5	he3lxvd601	163304	CVE-2022-21540,CVE-2022-21541,CVE-2022-21549,CVE-2022-25647,CVE-2022-34169	Oracle Java SE Multiple Vulnerabilities (July 2022 CPU)	Application Team-BTO	/pkgs/JDK/jdk170_55/	Installed version : 1.8.0_181	Fixed version : Upgrade to version 8.0.341 or greater
Results

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Parsing out data from a cel
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.