Wednesday, May 20, 2020

Adding double quote delimiters into csv file


1. open cmd and execute powershell.exe
2. run below command
import-csv D:\Test.csv | export-csv D:\Test_new.csv -NoTypeInformation -Encoding UTF8

Example:

D:\Test.csv

id,name,location
1,raj,Anantapur
2,siva,Hyderabad
3,venki,Bangalore

D:\Test_new.csv

"id","name","location"
"1","raj","Anantapur"
"2","siva","Hyderabad"
"3","venki","Bangalore"

No comments:

Post a Comment