February 2019
Intermediate to advanced
626 pages
15h 51m
English
Comma-Separated Value (CSV) files are plain text. Applications such as Microsoft Excel can work with CSV files without changing the file format, although the advanced features Excel has cannot be saved to a CSV file.
By default, Import-Csv expects input to have a header row, to be comma delimited, and to use ASCII file encoding. If any of these items are different, the command parameters may be used. For example, a tab may be set as the delimiter:
Import-Csv TabDelimitedFile.tsv -Delimiter `t
A tick followed by t (`t) is used to represent the tab character in PowerShell.
Data that's imported using Import-Csv will always be formatted as a string. If Import-Csv is used to read a file containing the following text, each ...
Read now
Unlock full access