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,
The csv file data is having the below row.
ID20,Value20,Automatic,"1,25,26,50",,Value1,Value2,Value3,Value4,Value5,Value6,Value7,Value8,Value9,Value10,Value11,Value12,Value13,Value14,Value15,Value16,,100,JP
Here, we need to retrieve "1,25,26,50" array.
The sample code is as below:
‘Creating the Driver….
DDT.CSVDriver(Projectsuite.Path&"FL_TestSuite_Driver_Testscript.csv")
Set Project.Variables.Inputs=DDT.CSVDriver(Projectsuite.Path&"FL_TestSuite_Driver_Inputs.csv")
.
.
.
.
.
.
‘Reading Value
ColValue=Project.Variables.Inputs.Value("Col1")
The csv file data is having the below row.
ID20,Value20,Automatic,"1,25,26,50",,Value1,Value2,Value3,Value4,Value5,Value6,Value7,Value8,Value9,Value10,Value11,Value12,Value13,Value14,Value15,Value16,,100,JP
Here, we need to retrieve "1,25,26,50" array.
The sample code is as below:
‘Creating the Driver….
DDT.CSVDriver(Projectsuite.Path&"FL_TestSuite_Driver_Testscript.csv")
Set Project.Variables.Inputs=DDT.CSVDriver(Projectsuite.Path&"FL_TestSuite_Driver_Inputs.csv")
.
.
.
.
.
.
‘Reading Value
ColValue=Project.Variables.Inputs.Value("Col1")