Bitbybit Docs
    Preparing search index...

    Class QueryColumnDto (Inputs.CSV)

    Feeds csv.queryColumn: the CSV text, the header name of the column to read, the row layout, the separators and whether to parse the values as numbers.

    Index

    Constructors

    • Parameters

      • Optionalcsv: string
      • Optionalcolumn: string
      • OptionalheaderRow: number
      • OptionaldataStartRow: number
      • OptionalrowSeparator: string
      • OptionalcolumnSeparator: string
      • OptionalasNumber: boolean

      Returns QueryColumnDto

    Properties

    csv: string

    The whole CSV text, headers included

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

    Header name of the column whose values are listed

    name
    
    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

    ,
    
    asNumber?: boolean

    When true, every value of the column is parsed as a number instead of staying text

    false