<div>
More information would be helpful. &nbsp;What exactly is a patching report? &nbsp;Can you provide a (small) sample file? &nbsp;I do not have access to RH but could help you given more information.<br />
<br />
Also, would a perl script be acceptable? &nbsp;In general, perl is king of text manipulation.
</div>


More information would be helpful.  What exactly is a patching report?  Can you provide a (small) sample file?  I do not have access to RH but could help you given more information.

Also, would a perl script be acceptable?  In general, perl is king of text manipulation.

<div>
Please find the following information.<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/05_w22/1421874/Patching-report-sample.xlsx" target="_blank" class="file-inline" title="Patching-report-sample.xlsx (9 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Patching-report-sample.xlsx</a>
</div>


Please find the following information.
Patching-report-sample.xlsx [https://filedb.experts-exchange.com/incoming/2019/05_w22/1421874/Patching-report-sample.xlsx]

Patching-report-sample.xlsx

<div>
<div class="content wysiwyg-content">
Hi Expert <br />
<br />
good day<br />
<br />
I trying to automate the process of manual generating of the patching report on the Redhat Linux distribution 7.3. <br />
<br />
Need help, how to generate a python script or shell script to capture the following output to a csv files.<br />
<br />
Errata ID, &nbsp;Severity, Package Name Packages, before patching and after patching. <br />
<br />
Many thanks
</div>
</div>


Hi Expert 

good day

I trying to automate the process of manual generating of the patching report on the Redhat Linux distribution 7.3. 

Need help, how to generate a python script or shell script to capture the following output to a csv files.

Errata ID,  Severity, Package Name Packages, before patching and after patching. 

Many thanks

Capture of Patching report

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in other languages. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive set of standard libraries, including NumPy, SciPy, Django, PyQuery, and PyLibrary.

Python

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.