Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to fetch the values from a CSV file to use it in the script ?

April 26, 2017csv fetch file Script values

0

Posted

How to fetch the values from a CSV file to use it in the script ?

1 Answer

0

Posted

To fetch data from a CSV file: • In the Add/View Data Configuration screen, from the Select DataSource Type combo, select the datasource type as CSV. • Enter the appropriate values for the following fields: • Select the csv file from the CSV File Name combo (if already available in /projects//dataset> directory) or create a new csv file name by clicking the Create CSV File link. Please note that the csv files displayed in the combo and the newly created csv files are placed in the server in /projects//dataset> directory. • Enter the start row index, end row index, start column index and end column index value from where the csv values has to be fetched. End row and end column index is optional. • Click the Apply button and then click Paste. This will paste the following script in the script editor. initDataSet(“CSV_login”)result = getValuesFrom(“CSV_login”) for i in range(0,len(result)): var1=str(result[i][0]) var2=str(result[i][1]) s