How to pipe an log file CSV in PowerShell?

Question

I would like to use PowerShell to parse a log, and output to a CSV file.

What is the basic way to accomplish this?

The do something in 4c74356b41's answer depends on the format of your log file. Eventually you can use import-csv your.log optionally with -header ColA ... — user6811411
– user6811411, Commented Nov 16, 2016 at 21:11
Yeah, I was concerned that formatting for each log file would have affect, thanks. — JDavila
– JDavila, Commented Nov 16, 2016 at 22:21

Emmanuel Galindo · Accepted Answer · 2016-11-16 21:46:12Z

1

Each log format involves it own logic when doing pattern matching, but I would propose to you something like:

(test.log is something like: date - context - type - msg)

$file = get-content test.log
$pattern = '^(.*) - (.*) - (.*) - (.*)$'
$findings = $file | select-string -pattern $pattern
$lines = foreach($f in $findings) {
    if ($f -match $pattern) { 
      $line = @{
           'date' = $matches[1]
           'context' = $matches[2]
           'level' = $matches[3]
           'message' = $matches[4]
      }
      new-object -typename psobject -property $line
    }
}
$lines | export-csv -notypeinformation -delimiter ';' -path 'test.csv'

answered Nov 16, 2016 at 21:46

Emmanuel Galindo

92 bronze badges

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

Comments

4c74356b41 · Accepted Answer · 2016-11-16 20:59:26Z

0

Get-Content | do something | Export-CSV

answered Nov 16, 2016 at 20:59

4c74356b41

71.4k7 gold badges118 silver badges155 bronze badges

Collectives™ on Stack Overflow

How to pipe an log file CSV in PowerShell?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related