Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex formatting help
From Rows to Columns
-------------------------------------------------------------------------------- My friend is trying to teach me that Excel is much easier than Sed and Awk, but I just cannot get the following raw data into correct column format without hours of manual work. Is it possible to automate this with Excel? Basically I need 6 columns with the headings of PDI Number, Finding Category, Reference, Description, Status, and For Example I have provided two PDI results below out of 400. As you can see, the For example changes size according to the finding but all other headings remain the same. Please help =========PDI=G033 Result======================== PDI Number: G033 Finding Category: CAT II Reference: UNIX STIG: 3.4.2 Description: Vendor recommended and security patches are not installed or are out-of-date. Status: Open For example: CRITICAL: Security Patch(es) Not Installed: (16). CRITICAL: Recommended Patch(es) Not Installed: (16). CRITICAL: Y2K Patch(es) Not Installed: (0). CRITICAL: Installed Recommended Patch(es) That Are Outdated: (148). OPTIONAL: System Software Patch(es) Not Installed/Outdated: (111). dcp2 Has (183) Missing/Old Critical Patch(es) dcp2 Has (111) Missing/Old System Software Patch(es). A full report is in /tmp/Script.March/dcp2/dcp2.patch.report. All patches listed may not apply to dcp2. ==========PDI=G037 Result======================== PDI Number: G037 Finding Category: CAT II Reference: UNIX STIG: 3.4.3 Description: System log file permissions are more permissive than 644. Status: Open For example: -rw-rw-r-- 1 root other 674436 Apr 20 11:37 /var/adm/lastlog -rw-rw-r-- 1 root other 658 Feb 15 14:52 /var/adm/loginlog |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex formatting help
Where is the raw data and how is it formatted?
Alok " wrote: From Rows to Columns -------------------------------------------------------------------------------- My friend is trying to teach me that Excel is much easier than Sed and Awk, but I just cannot get the following raw data into correct column format without hours of manual work. Is it possible to automate this with Excel? Basically I need 6 columns with the headings of PDI Number, Finding Category, Reference, Description, Status, and For Example I have provided two PDI results below out of 400. As you can see, the For example changes size according to the finding but all other headings remain the same. Please help =========PDI=G033 Result======================== PDI Number: G033 Finding Category: CAT II Reference: UNIX STIG: 3.4.2 Description: Vendor recommended and security patches are not installed or are out-of-date. Status: Open For example: CRITICAL: Security Patch(es) Not Installed: (16). CRITICAL: Recommended Patch(es) Not Installed: (16). CRITICAL: Y2K Patch(es) Not Installed: (0). CRITICAL: Installed Recommended Patch(es) That Are Outdated: (148). OPTIONAL: System Software Patch(es) Not Installed/Outdated: (111). dcp2 Has (183) Missing/Old Critical Patch(es) dcp2 Has (111) Missing/Old System Software Patch(es). A full report is in /tmp/Script.March/dcp2/dcp2.patch.report. All patches listed may not apply to dcp2. ==========PDI=G037 Result======================== PDI Number: G037 Finding Category: CAT II Reference: UNIX STIG: 3.4.3 Description: System log file permissions are more permissive than 644. Status: Open For example: -rw-rw-r-- 1 root other 674436 Apr 20 11:37 /var/adm/lastlog -rw-rw-r-- 1 root other 658 Feb 15 14:52 /var/adm/loginlog |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex conditional formatting | Excel Worksheet Functions | |||
Complex cond. formatting...Pls. Help! | Excel Discussion (Misc queries) | |||
Formula help for complex formatting. | Excel Worksheet Functions | |||
complex?? Q about Conditional formatting | Excel Worksheet Functions | |||
complex cell formatting using VBA | Excel Programming |