Delete double quotes just for header - PowerShellCommunity.org - Windows PowerShell Discussion Forums - Using PowerShell

Delete double quotes just for header

Last Post 04 Jul 2012 02:18 PM by jordan49. 6 Replies.

Sort:

	Prev Next
You are not authorized to post a reply.

Author

Messages

jordan49

New Member
Posts:11
Avatar

03 Jul 2012 11:55 AM
Hello, I'm looking a way to delete double quotes caractere in csv, but only for the first line... If i'm using this script : (Get-Content c:\users.csv) -replace('"','') \| Out-File C:\users.csv -force it's work but for all csv lines... For exemple, CSV looks like : "Name","Lastname" "Jordan" ,"Durand" I would like to have : Name,Lastname "Jordan" ,"Durand" Can you help me please ? Thanks.

EBGreen

Veteran Member
Posts:1276
Avatar

03 Jul 2012 12:01 PM
I'm curious why you would want to do this? The CSV snippet that you posted meets the CSV standard. Regardless here is one way: $replace = $true Get-Content c:\users.csv \| %{if($replace){$replace = $false; $_ -replace '"', ''}else{$_}} \| Out-file C:\users.csv -force

"Look Ma...no strings!"

jordan49

New Member
Posts:11
Avatar

03 Jul 2012 01:18 PM
I need to do that because the csv file is used with another script to populate SharePoint contact list. If the double quotes are not deleted for the header, the list is populated by blank contact. Without quotes, it's works. I have tested your script, but the csv become blank (all content was deleted.)..

RiffyRiot

Basic Member
Posts:329
Avatar

03 Jul 2012 04:31 PM
The method EBGreen posted works for me. Here's another way... ## create sample file $mynames=@" "Name","Lastname" "Jordan","Durand" "@ $mynames \| Out-File 'c:\temp\names.csv' $mynames=get-content 'c:\temp\names.csv' $mynames[0]=$mynames[0] -replace '"','' $mynames \| set-content 'c:\temp\names.csv'

Rule #1: You should only use Format-Table as the final command in the pipeline and only when you're not using the output for anything else

jordan49

New Member
Posts:11
Avatar

04 Jul 2012 12:17 AM
Hello, thanks RiffyRiot but i can't edit my CSV file so is there another way to do that ? I have try againt the script of EBGreen but my CSV file becomes empty...

RiffyRiot

Basic Member
Posts:329
Avatar

04 Jul 2012 01:55 PM
This script... $mynames=get-content 'c:\temp\names.csv' $mynames[0]=$mynames[0] -replace '"','' $mynames \| set-content 'c:\temp\names.csv' does pretty much the same as what's in your first post... (Get-Content c:\users.csv) -replace('"','') \| Out-File C:\users.csv -force but only for the first line of the file. Both are 'editing my CSV file' What do you mean 'I can't edit my CSV file'?

Rule #1: You should only use Format-Table as the final command in the pipeline and only when you're not using the output for anything else

jordan49

New Member
Posts:11
Avatar

04 Jul 2012 02:18 PM
Thanks RiffyRiot, it works now ;)

You are not authorized to post a reply.

Active Forums 4.3