import-csv missing charakters

Hello,

Using the powershell cmdlet IMPORT-CSV, special Characters (ä,ö,ü) get lost.

My Test:

content of af file test.csv:
english, german
door, tür

Powershell:
PS C:\Test> $a= ipcsv .\text.csv
$a
english german
------- ------
door tr

If I use instead GET-CONTENT it works the right way:

Powershell:
PS C:\Test> $a= gc .\text.csv
PS C:\Test> $a
english, german
door, tür

I'd like to use IMPORT-CSV as it's more convenient.
Any Idea how to handle special characters?

Regards,
Christoph

It will work if the format of the file is Unicode :

PoSH> Set-Content text.txt -Encoding Unicode @'
>> english, german
>> door, tür
>> '@
>>

PoSH> Import-Csv text.txt

english german
------- ------
door tür

but I think this should also be supported on ANSI and / or an -Encoding
parameter on Import-Csv should be provided

Greetings /\/\o\/\/
http:/thePowerShellGuy.com


"Christoph Jandek" wrote:

> Hello,
>
> Using the powershell cmdlet IMPORT-CSV, special Characters (ä,ö,ü) get lost.
>
> My Test:
>
> content of af file test.csv:
> english, german
> door, tür
>
> Powershell:
> PS C:\Test> $a= ipcsv .\text.csv
> $a
> english german
> ------- ------
> door tr
>
> If I use instead GET-CONTENT it works the right way:
>
> Powershell:
> PS C:\Test> $a= gc .\text.csv
> PS C:\Test> $a
> english, german
> door, tür
>
> I'd like to use IMPORT-CSV as it's more convenient.
> Any Idea how to handle special characters?
>
> Regards,
> Christoph
>

Thank you for the fast response.

It works fine with Unicode or UTF-8.
The errrors occur with an ASCII-File, which was created by an Exchange 5.5
export.

I can pipe the ASCII-File to an Unicode File for using IMPORT-CSV.
Or is there a better way, as GET-CONTENT works fine?

Regards,
Christoph



"/\/\o\/\/ [MVP]" wrote:

> It will work if the format of the file is Unicode :
>
> PoSH> Set-Content text.txt -Encoding Unicode @'
> >> english, german
> >> door, tür
> >> '@
> >>
>
> PoSH> Import-Csv text.txt
>
> english german
> ------- ------
> door tür
>
> but I think this should also be supported on ANSI and / or an -Encoding
> parameter on Import-Csv should be provided
>
> Greetings /\/\o\/\/
> http:/thePowerShellGuy.com
>
>
> "Christoph Jandek" wrote:
>
> > Hello,
> >
> > Using the powershell cmdlet IMPORT-CSV, special Characters (ä,ö,ü) get lost.
> >
> > My Test:
> >
> > content of af file test.csv:
> > english, german
> > door, tür
> >
> > Powershell:
> > PS C:\Test> $a= ipcsv .\text.csv
> > $a
> > english german
> > ------- ------
> > door tr
> >
> > If I use instead GET-CONTENT it works the right way:
> >
> > Powershell:
> > PS C:\Test> $a= gc .\text.csv
> > PS C:\Test> $a
> > english, german
> > door, tür
> >
> > I'd like to use IMPORT-CSV as it's more convenient.
> > Any Idea how to handle special characters?
> >
> > Regards,
> > Christoph
> >

get-content defaults to reading in utf8 encoding, hence why it works.
import-csv, for some unknown reason, is defaulting to ascii encoding. So
your workaround
cat test.csv > test2.csv # make utf8
should work until they fix import-csv.

--
William Stacey [C# MVP]
PowerLocker, PowerPad
www.powerlocker.com



"Christoph Jandek" <ChristophJandek@discussions.microsoft.com> wrote in
message news:45FED266-2CDF-4191-B854-4945B52DFE02@microsoft.com...
| Thank you for the fast response.
|
| It works fine with Unicode or UTF-8.
| The errrors occur with an ASCII-File, which was created by an Exchange 5.5
| export.
|
| I can pipe the ASCII-File to an Unicode File for using IMPORT-CSV.
| Or is there a better way, as GET-CONTENT works fine?
|
| Regards,
| Christoph
|
|
|
| "/\/\o\/\/ [MVP]" wrote:
|
| > It will work if the format of the file is Unicode :
| >
| > PoSH> Set-Content text.txt -Encoding Unicode @'
| > >> english, german
| > >> door, tür
| > >> '@
| > >>
| >
| > PoSH> Import-Csv text.txt
| >
| > english
german
|
------
| > door
tür
| >
| > but I think this should also be supported on ANSI and / or an -Encoding
| > parameter on Import-Csv should be provided
| >
| > Greetings /\/\o\/\/
| > http:/thePowerShellGuy.com
| >
| >
| > "Christoph Jandek" wrote:
| >
| > > Hello,
| > >
| > > Using the powershell cmdlet IMPORT-CSV, special Characters (ä,ö,ü) get
lost.
| > >
| > > My Test:
| > >
| > > content of af file test.csv:
| > > english, german
| > > door, tür
| > >
| > > Powershell:
| > > PS C:\Test> $a= ipcsv .\text.csv
| > > $a
| > > english german
| > > ------- ------
| > > door tr
| > >
| > > If I use instead GET-CONTENT it works the right way:
| > >
| > > Powershell:
| > > PS C:\Test> $a= gc .\text.csv
| > > PS C:\Test> $a
| > > english, german
| > > door, tür
| > >
| > > I'd like to use IMPORT-CSV as it's more convenient.
| > > Any Idea how to handle special characters?
| > >
| > > Regards,
| > > Christoph
| > >