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

Delete Row Button to all records of Interactive Report in Oracle Apex

 1. add 'Delete' Del column to Report Query 2. Set the Following Properties for the DEL Column Type: Link Heading: Delete Targ...