How to import a tab delimited text file using Import-CSV when the file does not have a header line?

Question

I have a huge text file (about 500 MB) with a tab delimiter. It does not contain headers. It looks like this:

20140711   IBM   29.9068    [e-mail]    this is interesting
20140712   HP   2.3000    [e-mail]    this is interesting
20140713   GOOGLE   44.9033    [e-mail]    this is interesting
20140714   HTC   739.70    [e-mail]    this is interesting
20140715   SAMSUNG   8.442    [e-mail]    this is interesting
20140716   MICROSOFT   67.104    [e-mail]    this is interesting
20140717   DELL   5.0823    [e-mail]    this is interesting
...
...
...

I need to use Powershell to load text into a SQL Server database as a table. Since there are no headers in the text file, the Import-Csv cmdlet does not display the contents correctly. I think it always treats the first line as headers.

How does "Import-Csv" display the entire contents of a text file and forget about the header configuration?

Thank.

Answer 1

You can try the following:

$data = Import-Csv C:\temp\F.csv -Header "date","company","value","mail","description" -Delimiter "`t"

Answer 2

, "-Raw".

- :

$header= "Date   EventLog   EntryType"
(get-content -Raw $File) | foreach-object {$_ -replace "^", "$header`n"} | set-content  $File

Answer 3

$header3 = @("Column_1","Column_2","Column_3","Column_4","Column_5")        

$data = Import-Csv $filePath -Header $header3 -Delimiter "`t"