Import-CSV in PowerShell hides double quotes

Question

Import-CSV in PowerShell hides double quotes

I import a file and process its contents like this:

$msg = Import-Csv .\content -Delimiter "`t" | Select msg | Format-Table -HideTableHeaders | Out-String | %{$_ -replace "\n"}

In this case, the content file looks like this:

id  name    when    ip  msg user_id
 50 Felix   2015-07-22 12:51:04 10.1.100.6  "ein link":www.link.de  89

But $ msg returns the following:

ein link:www.link.de

When I have a content file like:

id  name    when    ip  msg user_id
 50 Felix   2015-07-22 12:51:04 10.1.100.6  dies ist "ein link":www.link.de 89

$ msg is correct:

dies ist "ein link":www.link.de

Import-CSV only hides double quotes when they appear at the beginning of text.

I am working with PowerShell 5.0

Can you help me?

thank

+3

powershell quotes csv

FLX 22 jul. 15 at 11:23

source to share

1 answer

CB. · Answer 1 · 2015-07-22T13:47:09+0000

try it, maybe it works:

$msg = Get-Content .\content.csv |
       ForEach-Object { $_ -replace ('"','"""') } | 
       ConvertFrom-CSV -Delimiter "`t" | 
       Select msg | Format-Table -HideTableHeaders | 
       Out-String | %{$_ -replace "\n"}

Import-CSV in PowerShell hides double quotes

More articles: