csvToArray ( string path , string _separator , string _lineEnd , string _encoding ) : array
Return a mapped array of data in csv. Ex : [ ["name":"Dupont","age":15] , ["name":"Fred","age":16] ]
Note: for table keys, all accents are replaced by simple letters (ex: é become e)
IMPORTANT ! If there is a problem
Try to replace by csvToArray2 or csvToArray3, alternative functions (but it can bad interpret some separating caracters like , or new line when they are in a string).See also
csvExample
csvToArray(path("desktop")+"file.csv");
csvToArray(path("desktop")+"ile.csv", ",");
csvToArray(path("desktop")+"file.csv", ",", "\r\n");
csvToArray(path("desktop")+"file.csv", ";", "\n", "UTF-8");
Parameters
path
_separator (optional)
default:";"
_lineEnd (optional)
default:"\n"
_encoding (optional)
default:"ISO-8859-15". It is the encoding algorithm. You can change for "UTF-8" for example.