Parse a report with powershell

Question

I'm trying to gather some statistics using powershell.

I have about 4,000 reports that look like this (all in their own Report.txt files - some have more fields. I've sniped it):

What I would like to do (thinking out loud) is take each [ ] and make that a csv header and then add each item under that header under it. Then I can run simple count statements against it and pull out some data. Maybe there is a better/easier way?

The idea is to have some like:

Requested Permissions: android.permission.INTERNET 3,562 of 4,000 Requested Permissions: android.permission.READ_SMS 1 of 4,000 etc...

So far i've stripped down the string so it no longer has white spaces and *.

[ Package name ]
 * com.software.application

[ Requested Permissions ]
 * android.permission.INTERNET
 * android.permission.READ_PHONE_STATE
 * android.permission.READ_SMS
 * android.permission.RECEIVE_SMS
 * android.permission.SEND_SMS
 * android.permission.WAKE_LOCK
 * android.permission.WRITE_EXTERNAL_STORAGE
 * com.google.android.c2dm.permission.RECEIVE
 * com.software.application.permission.C2D_MESSAGE

[ Responsible API calls for used Permissions ]
 * android/app/NotificationManager;->notify
 * android/content/Context;->sendBroadcast
 * android/content/Context;->startService
 * android/os/PowerManager$WakeLock;->acquire
 * android/os/PowerManager$WakeLock;->release
 * android/telephony/SmsManager;->sendTextMessage

[ Potentially dangerous Calls ]
 * getSystemService
 * HttpPost
 * sendSMS

Current output example:

[PotentiallydangerousCalls]
getSystemService
HttpPost
sendSMS

So it's a bit cleaner now...

JPBlanc · Accepted Answer · 2013-04-07 19:26:14Z

1

I will put some code if I have time, but here is a roadbook :

1) Write a function (CsvToObject) that take the path and name of a csv file and return a PSObject with a property with each [value]

This function can take advantage of switch ... case PowerShell structure with regex and file usage.

2) Take every *.csv file (Get-ChildItem) , call your function and pipe the result in Export-CSV

edited Apr 7, 2013 at 19:26

answered Apr 7, 2013 at 6:38

JPBlanc

73.1k18 gold badges137 silver badges180 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:03:20Z

0

Your current output example is structured like an ini file. This Scripting Guy post on ini files might be useful. Some regex help here and here.

edited May 23, 2017 at 12:03

CommunityBot

11 silver badge

answered Apr 7, 2013 at 16:11

noam

2,0152 gold badges21 silver badges26 bronze badges

Collectives™ on Stack Overflow

Parse a report with powershell

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related