quarta-feira, 7 de setembro de 2016

Powershell - CSV

Export to a CSV file

 Export-csv $Path -NoTypeInformation -Delimiter ';' -Encoding utf8 -Append

 -Delimiter: Chose one different delimiter. By default is comma (,).

 -NoTypeInformation: Omits the type inforamtion header from output. By default, the string in the output contains #TYPE followed by fully-qualified name of the object type.

 -Encoding: Chose a different Encoding. utf8 is used to french characters. By default is English.

 -Append: Append to an exist file


Import a CSV file

  Import-csv $Path

Nenhum comentário:

Postar um comentário