Availability
This routine is available since katl-commons 4.0.8 .
Syntax:
readFromCSVFile(path, hasHeader [, charset])
Description:
Read the values from the CSV filem, returning them into an array, of N rows * M columns valuesParameters:
Parameter name | Type | Required | Description |
|---|---|---|---|
path | string | Yes | Specifies the file name to read from. |
| hasHeader | boolean | Yes | Specifies if the file has header. |
| charset | string | No | Specifies the charset used to read that file. |
Return type:
string []
The values from the file, as a string array.
Example:
On it's basic form, the routine can be used like simply:
string [] fileContent = readFromCSVFile("C:/test.csv", true);
However, in its bare form is hardly usable. A better usage is exemplified below:
//Suppose we have a CSV file with 3 columns, First Name, Last Name, Age
struct Emp {
string fName;
string lName;
number age;
}
Emp [] fileContent = readFromCSVFile("C:/test.csv", true);
for(Emp e in fileContent) {
//we can address them now in a better way .... so process row after row
string s = e.fName + " " + e.lName + " / " + e.age;
//do smth with that 's'
}
Unless calendaristic dates are in formats SIL can understand, dates should be imported as strings and further parsed afterwards in your SIL program.
Notes:
- You can use absolute paths and relative paths to "sil.home".
- If the header exist, it must not have duplicated columns, otherwise you need to skip it manually
- If the file is not found, an error will be raised.
See also: