Index: Create a drop-down list from the values of a file

File to read

TestlistCode.csv

Script

var result = new JSE_Result();
var content = JSE_File.readFile('C:\OPENBEE\Test\TestlistCode.csv');
if(content == null || content == "")
	return result;
var list = content.split("\n");
if(list.length == 0)
	return result;

var code = getTextFromIndexInfo(getFirstIndexFromID(pParameters, "CODE_INDEX"));
var values = [];
values.push("");

for(var i=0;i<list.length;i++){
	var line = list[i].split(";");
	if(line != null && line.length > 0){
		values.push(line[0].trim());
		if(line[0] != null && line[0] != "" && line[0] == code)
			result.calculatedValue = line[0].trim();
	}
}
result.values = values;
return result;

Result