How to select required columns in csv file using powershell

Question

I have a csv file with data looking like this.

Div,Date,HomeTeam,AwayTeam,FTHG,FTAG,FTR,HTHG,HTAG,HTR
I1,20/08/16,Juventus,Fiorentina,2,1,H,1,0,H
I1,20/08/16,Roma,Udinese,4,0,H,0,0,D
I1,21/08/16,Atalanta,Lazio,3,4,A,0,3,A
I1,21/08/16,Bologna,Crotone,1,0,H,0,0,D

I am trying to export first six columns like below to a new csv file.

Div,Date,HomeTeam,AwayTeam,FTHG,FTAG
I1,20/08/16,Juventus,Fiorentina,2,1
I1,20/08/16,Roma,Udinese,4,0
I1,21/08/16,Atalanta,Lazio,3,4
I1,21/08/16,Bologna,Crotone,1,0

I am using the following powershell command.

Import-Csv $infile -DeLimiter ","|
Select'Div','Date','HomeTeam','AwayTeam','FTHG','FTAG'| 
Export-Csv $trimfile -DeLimiter "," -NoTypeInformation

But my output csv file looks like this

"Div","Date","HomeTeam","AwayTeam","FTHG","FTAG"
"I1","20/08/16","Juventus","Fiorentina","2","1"
"I1","20/08/16","Roma","Udinese","4","0"
"I1","21/08/16","Atalanta","Lazio","3","4"
"I1","21/08/16","Bologna","Crotone","1","0"

The no.of columns are much higher in the actual file. Simplified it here. What am I doing wrong?

What's wrong? The quotes? 99% of csv-capable Readers understands and removes them.. — Frode F.
– Frode F., Commented Apr 24, 2017 at 6:58
yes. Then I have to import the data into sqlite, where the qoutes appear in all fields. — Ram Kumar
– Ram Kumar, Commented Apr 24, 2017 at 7:05

Manu · Accepted Answer · 2017-04-24 07:45:09Z

3

Try with this code :

Import-Csv $infile -DeLimiter "," | 
Select-Object 'Div','Date','HomeTeam','AwayTeam','FTHG','FTAG' | 
ConvertTo-Csv -NoTypeInformation | 
ForEach-Object { $_ -replace '"', ""} | 
Out-File $trimfile

answered Apr 24, 2017 at 7:45

Manu

1,74214 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to select required columns in csv file using powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related