Bitbybit Docs
    Preparing search index...

    Class QueryRowsByValueDto (Inputs.CSV)

    Feeds csv.queryRowsByValue: the CSV text, the column to test and the value it must equal, the row layout, the separators and the columns read as numbers.

    Index

    Constructors

    constructor

    Properties

    csv column value headerRow? dataStartRow? rowSeparator? columnSeparator? numberColumns?

    Constructors

    • Parameters

      • Optionalcsv: string
      • Optionalcolumn: string
      • Optionalvalue: string
      • OptionalheaderRow: number
      • OptionaldataStartRow: number
      • OptionalrowSeparator: string
      • OptionalcolumnSeparator: string
      • OptionalnumberColumns: string[]

      Returns QueryRowsByValueDto

    Properties

    csv: string

    The whole CSV text, headers included

    name,age\nJohn,30\nJane,25
    column: string

    Header name of the column that is compared with value

    age
    value: string

    The text a row's cell must equal to be kept; compared as a number when the column is in numberColumns

    30
    headerRow?: number

    Index of the row whose cells are the header names, counting from 0

    0

    0

    Infinity

    1

    dataStartRow?: number

    Index of the first row read as data, counting from 0; normally the row after the headers

    1

    0

    Infinity

    1

    rowSeparator?: string

    The text between rows, normally a line break; \n written as two characters is read as one

    \n
    columnSeparator?: string

    The text between cells in a row, normally a comma; \t written as two characters is read as a tab

    ,
    numberColumns?: string[]

    Header names whose cells are parsed as numbers, in the result and in the comparison

    undefined

    true

    Settings

    Member Visibility

    On This Page

    Constructors
    Properties