Thanks for the answer, but it's not very usefull.
0) Work with a SMALL BATCH size of records; (ie microservices, smallish user stories) you will realize efficiency when using a small batch of CSV records to locate and fix the root-cause. In Prisma Cloud Compliancy report, even if you select a small set ( for example all the image running as root ) you get a larger report with all the issues for the involved image.
1) @JNeytchev offered good advice for locating your root causes. -> it's enough to open the .csv with excell to findout the raw with issue.
2) You need an editor like (ie vi, vim) that can perform "stream edits" over sections or entire file. Too tiem consuming. Anyway Libreoffice seems the best solution
3) Manually search the file, perhaps, developing a regular expression that can detect only the defective fields. ALready tried, too different situations. ( same for the othert suggestions, at this point Libreoffice and a lot of time seems the best approach ).
... View more