Convert LOG file to CSV

[SCharchouf]

I need to convert a LOG file to CSV is that possible?

[LucD]

What kind of log?
And is this a PowerCLI related question?

[SCharchouf]

the output is a LOG of running a PowerCLi commands to check some parameters.

the output is like this

2020-11-10][23:04:23] - Success - PowerCLI module exists

[2020-11-10][23:04:25] - Control - ############# Check VIB Acceptance Level #############
[2020-11-10][23:04:43] - Success -HostLab : Acceptance Level 'PartnerSupported'

[2020-11-10][23:04:46] - Success -Host1 : Acceptance Level 'PartnerSupported'

[2020-11-10][23:04:46] - Control - ############# Check NTP Configuration #############

[LucD]

Moved post to VMware PowerCLI Discussions

[LucD]

What fields/columns do you want in the CSV?
How should these lines be split?

[LucD]

A question though.
Why first go through the trouble of showing that information in a log and then converting that log into a CSV.
It would be a lot simpler to write to a CSV directly

[SCharchouf]

I need the LOG as it's mandatory as a proof of activity

the reason why I'm trying to convert to CSV in order to explore data in Excel 😊

[LucD]

You can create a log from the CSV, which imho is way easier than creating a CSV from a log.

[SCharchouf]

it would be a greate idea but not sure how to proceed 🙂

and I believe this is will require a huge change in the script, right?

[LucD]

I can't really tell without seeing the script and how you create those log lines.

[SCharchouf]

Totally agree, may I share it in private?

[LucD]

Sure, send me a PM

[SCharchouf]

sorry for the delay, Message sent

since the update I no longer receive notifications. I will check the configuration of my profile.