Re: converting line input into columns

Dr. Ruud,

Yes. Thats exacty what I am tryint to do. Here is the actual sample
from the file I am trying to parse:

-----------------------
Physical Security
Severity : Cat II / Important
Status : Unknown
PDI ID : 1836

Finding Details
This vulnerability could not be checked by the program, it must be
checked manually.

Vulnerability Discussion
Category: II
Inadequate physical protection can undermine all other security
precautions utilized to protect the system. This can jeopardize the
confidentiality, availability, and integrity of the system. Physical
security of the individual machine is the first line protection of any
system.

Manual Fix Procedures
Ensure the computer equipment is located in a protected controlled
access area.

References and additional information
FSO Checklist: 3.1
CJCSM 6510.01, C-D.3



Administrator Documentation
Severity : Cat II / Important
Status : Unknown
PDI ID : 1788

Finding Details
This vulnerability could not be checked by the program, it must be
checked manually.

Vulnerability Discussion
Category: II
Using a privileged account to perform routine functions makes the
computer vulnerable to attack by any virus or Trojan Horse
inadvertently introduced during a session that has been granted full
privileges.

The rule of least privilege should always be enforced.

Manual Fix Procedures
Ensure administrative personnel have two accounts assigned, a standard
user account and an account with membership in the Administrators
group. Personnel should be instructed to use the less privileged
account for day-to-day use.

Each System Administrator will have a unique userid dedicated for
administering the system.
Each System Administrator will have a separate account for normal user
tasks.
The built-in Administrator account will not used to administer the
system.
Administrators will be properly trained.
The IAO will maintain a list of users belonging to the Administrators
group.

References and additional information
FSO Checklist: 3.2
DODI 8200.2, E3.4.7
CJCSM 6510.01, A-A.3
---------------
I need everyting after the : and everyting (multiple lines in some
cases) to put in CSV format, so I can import it to excel.

Please advice.

Thanks,
AV

Dr.Ruud wrote:
vanagas99@xxxxxxxxx schreef:

Severity: Important
Status: Unknown
PDI ID: 1895
Finding Details
This vulnerability... blah, blah, blah
Vulnerability Discussion
blah, blah, blah text
Fix recommendations
blah, blah, blah text

It looks like <newline><whitespace> has the same functionality as
<colon><space>.

By "column type", do you mean that the header field names should be
assembled in a header line, like CSV?

Severity,Status,PDI ID,Finding Details,Vulnerability Discussion,Fix
recommendations
Important,Unknown,1895,"This vulnerability... blah, blah, blah","blah,
blah, blah text","blah, blah, blah text"

--
Affijn, Ruud

"Gewoon is een tijger."

.

Relevant Pages

  • Re: complicated parsing from the file
    ... Finding Details ... This vulnerability could not be checked by the program, ... Using a privileged account to perform routine functions makes the ... Administrators will be properly trained. ...
    (perl.beginners)
  • Re: complicated parsing from the file
    ... This vulnerability could not be checked by the program, ... Using a privileged account to perform routine functions makes the ... privileges. ... Administrators will be properly trained. ...
    (perl.beginners)
  • Re: complicated parsing from the file
    ... PDI ID: 1836 ... This vulnerability could not be checked by the program, ... Using a privileged account to perform routine functions makes the ... Administrators will be properly trained. ...
    (perl.beginners)
  • complicated parsing from the file
    ... PDI ID: 1836 ... This vulnerability could not be checked by the program, ... Using a privileged account to perform routine functions makes the ... Administrators will be properly trained. ...
    (perl.beginners)
  • Re: Free Snail mail Remailing Service...
    ... Cyberiade.it Anonymous Remailer wrote: ... There is no account, no records, nothing to ... Very simple, very secure. ... we never keep records, steam open mail, blah deblah ...
    (alt.privacy)