Hi,
I have drawn a graph which reads the CSV file and upload it to database.
Following character are given for testing special characters in the CSV.
1.Sample,XXX,XXX,Sample
2.sample,”XXX”,”XXX”,sample
The characters with comma is considered as delimiter of the line and skip, but we want it to update or insert it into the DB.
Please do let me know how clover etl handles special characters in the csv files.
Thanks,
Bala
I have drawn a graph which reads the CSV file and upload it to database.
Following character are given for testing special characters in the CSV.
1.Sample,XXX,XXX,Sample
2.sample,”XXX”,”XXX”,sample
The characters with comma is considered as delimiter of the line and skip, but we want it to update or insert it into the DB.
Please do let me know how clover etl handles special characters in the csv files.
Thanks,
Bala
-
Hello Bala,
reading following topic would help to solve your problem viewtopic.php?f=4&t=528&hilit=+delimiter
Please sign in to leave a comment.
Comments 1