Reading array of values from CSV File
Hi, While reading csv Files, we are not able to read array of values(Which is enclosed within double quotes). The value is returned as NULL. Could you please help us in this. Rega...
Forum Discussion
Hi Deepa
I'm not sure do you have header row in csv or not, I'd recommend to add header column.
e.g
Col1, Col2, Col3, Col4, Col5
ID20,Value20,Automatic,"1,25,26,50","1,29,36,80"
I'm not sure do you have header row in csv or not, I'd recommend to add header column.
e.g
Col1, Col2, Col3, Col4, Col5
ID20,Value20,Automatic,"1,25,26,50","1,29,36,80"
You have to create Schema.ini file at same directory where your CSV file is located.
and replace your CSV file name in first line, (file name must be in square brackets).
[FileName.csv]
Format=CSVDelimited
ColNameHeader=True
MaxScanRows=0
I have not tested by storing DDT.CSVDriver reference in project variable but I hope it will resolve your issue.
Regards
Mughees Siddiqui