csvToArray

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

csv

Example



        
        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.