LoadVariableCSV (change the delimiter)

[ali_hijazi]

Hello
I have the variables of an application defined in an excel file from which I saved a copy as CSV with semi-column as separator
Now I want to import the variables using the LoadVariableCSV function 

However, I'm getting an error as the ";" is not recognized and it seems that the function uses comma as a separator?
kindly advise
@Michael_Tarallo 
@Anonymous 
@Magnus_Berg 

[Magnus_Berg · Accepted solution]

Hi Ali, sorry for late reply. Yes that function uses comma as separator. The reason is that the function parse the file into the script and as the qlik script uses ";" as line breaks its a security measure not to break the script. There is examples how a file should look in the framework demo container. example:
VariableName,VariableValue,Comments,Priority
vKPI.SumYear1997,"Sum(If(Year(OrderDate)=1997, Quantity*UnitPrice))","Sum last year",Sales

[ali_hijazi]

Hello @Magnus_Berg 
I did like you asked me to do above however I'm getting the double quotations in the definitions of the variables

kindly advise