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
Results i am looking for
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 |
Last edited: