csvParse

type Cell struct {
	Row    int // start row is 0
	Column int // start column is 0
}

type CellLocation struct {
	Location Cell
	DataType DataType
	Name     string // Alias that will be used if not blank
	NameCell Cell   // Location for the name cell. Will be ignored if Name is not blank
}

type ConcatCellLocation struct {
	Cells     []Cell // List of cells in order to be concatenated
	Delimiter string // Delimiter to use between cells
	Name      string // Alias that will be used if not blank
	NameCell  Cell   // Location for the name cell. Will be ignored if Name is not blank
	DataType  DataType
}

type Csv struct {
	FilePathData        []FilePathData
	PreProcessor        []Processor
	CellLocations       []CellLocation
	ConcatCellLocations []ConcatCellLocation
	TableLocations      []TableLocation
	TimeFields          []TimeField
	IdField             IdField
	FaultOnDuplicate    bool
	KeepSpaces          bool
	StoreFileTime       bool
	FileTimeName        string
}

type DataType int

type FilePathData struct {
	Name          string
	StartLocation uint16
	EndLocation   uint16

	// must have capture groups defined or no data will be found
	//
	// will be ignored if empty
	// capture group names will be used as the key
	CaptureRegex string
	// contains filtered or unexported fields
}

type Float64 float64 // Custom type to handle mapping with decimals

type IdField struct {
	// a grouping of parameters tht can be any depth into the data
	Parameters []IdFieldParameter

	Delimiter string
}

type IdFieldParameter struct {
	Mapping []any
}

type Processor interface {
	GetName() string
	Execute(records [][]string) ([][]string, error)
	GetType() ProcessorType
	SetType()
}

type ProcessorFillRight struct {
	Type  ProcessorType
	Name  string
	Start Cell
	End   Cell // Set Row = -1 if you want to do all rows, Set Column = -1 if you want to do all columns
}

type ProcessorMergeColumns struct {
	Type      ProcessorType
	Name      string
	Start     Cell
	End       Cell // Set Row = -1 if you want to do all rows, Set Column = -1 if you want to do all columns
	Delimiter string
}

type ProcessorMergeRows struct {
	Type           ProcessorType
	Name           string
	StartRow       int
	EndRow         int
	Delimiter      string
	TrimWhitespace bool
}

type ProcessorRemoveCellLeft struct {
	Type ProcessorType
	Name string
	Cell Cell
}

type ProcessorReplaceCell struct {
	Type  ProcessorType
	Name  string
	Cell  Cell
	Value string
}

type ProcessorTransposeRow struct {
	Type     ProcessorType
	Name     string
	StartRow int
	EndRow   int
}

type ProcessorType int

type TableLocation struct {
	Name                string // name of the table. will be used instead of NameLocation if both are provided
	NameLocation        Cell   // if not 0, 0 it will be used to identify the name of the table
	StartCell           Cell
	EndCell             Cell       // if 0, 0 or equal to start cell it will not execute. Negative values will be treated as the end of the row or column
	HeaderNames         []string   // Ignored if TableHasHeader is true
	ColumnDataTypes     []DataType // Ignored if AutoColumnDataTypes is true.
	TableHasHeader      bool       // Whether the first row is the header row or not
	AutoColumnDataTypes bool       // if true will automatically infer column data types from the data
	SkipBlankData       bool       // Skips returning data for a cell if the cell is blank
	ParseAsArray        bool       // If true will parse the fields as an array instead of a JSON list
	ParseSingleRow      bool       // If true will only take the first row (or row beneath header) regardless of number of rows
	ParseSeparated      bool       // If true will segment table into multiple maps
	IgnoreNesting       bool       // If true will not nest the fields under the table name
}

type TimeField struct {
	Cells  []Cell // List of cells. Can be concatenated if the time field spans multiple areas
	Layout string
	Name   string
}