Forum Discussion

Johnn200's avatar
Johnn200
Copper Contributor
Dec 17, 2020

How I can separately data in 1 column from a csv file to others columns with header ?

Dear supporter,   Thank you for your visit, I'm a very new with Powershell data array, I have a question and I hope you can help me:   I have a .csv file with 3 column, "Auditdata" is one of them...
Windows PowerShell
  • AndySvints's avatar
    AndySvints
    Dec 17, 2020

    Hello Johnn200,

    It looks like your AuditData is in Json notation.

    Please try to use ConvertFrom-Json

    Simply pipe your AuditData to ConvertFrom-Json and then you will be able to filter it easily.

     

    Hope that helps.

AndySvints's avatar
AndySvints
Steel Contributor
Dec 17, 2020

Hello Johnn200,

It looks like your AuditData is in Json notation.

Please try to use ConvertFrom-Json

Simply pipe your AuditData to ConvertFrom-Json and then you will be able to filter it easily.

 

Hope that helps.

  • Johnn200's avatar
    Johnn200
    Copper Contributor
    Dec 18, 2020
    Perfect comment Andy. Thank you very much

    I'm now can work with those data now. Learned new thing today.

    Thank you.

Resources