Link Search Menu Expand Document

CSVDocument.Find Method

Explanation Search CSVData under specified conditions and returns the first row index found from the rows.
Call format var ret = csvdoc.Find( row [, cond1 [, cond2, … ] ] )
Return value Return row that starts from number 0 that first matches the specified condition.
If matches row is not found, -1 is returned.
Arguments integer row Return row with index 0 from row to start the search.
Row after specified row will be searched.
String cond Search condition.
Specify as the same format as Load method.
Can specify as many search conditions, as long as the maximum condition is same with number of columns, and to specify more than one condition, combine them with AND.
Exception None
Example of use
    var csvdoc = new CSVDocument;
    csvdoc << Form1.Spread1.row;
    var row = csvdoc.Find(0, "0==X11", "3n<100");
    Form1.Spread1.Value = row;
    
Related item Load, Replace methods