Versions Compared

Old Version 1

changes.mady.by.user Ana Gologan (Deactivated)

Saved on

compared with

New Version 2

changes.mady.by.user Radu Dumitriu (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Description:

Excerpt

Read the text values from the CSV file.filem, returning them into an array, of N rows * M columns values

Parameters:

Parameter name

Type

Required

Description

path

string

Yes

Specifies the file name to read from.

hasHeaderbooleanYesSpecifies if the file has header.
charsetstringNoSpecifies the charset used to read that file.

Return type:

string []

The text of the file values from the file, as a string array.

 

Example:

On it's basic form, the routine can be used like simply:

Code Block
string [] fileContent = readFromCSVFile("C:/test.csv", true);


However, in its bare form is hardly usable. A better usage is exemplified below:


Code Block
//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:

Note
  1. You can use absolute paths and relative paths to "sil.home".
  2. If the header exist, it must not have duplicated columns, otherwise you need to skip it manually
  3.  If the file is not found, an error will be raised.

...