INNOV-AI

Innovation and Research from Réunion Island, France

Back   Home

FX - CSV @ File format @ MentDB Weak

> Start the server
> (or start the server for the first time (embedded mode - H2 Database))
> (or start the server for the first time (remote mode - MySQL 8 Database))
> Open the MentDB Weak Editor

CSV
csv parse

csv parse <namespace> <filePath> <columnSeparator> <quoteChar> <forceColumnNames> <mqlAction>


Description

    Parse CSV file

Parameters

    namespace:   The namespace - string - required
    filePath:   The file path - string - required
    columnSeparator:   The column separator - string - required
    quoteChar:   The quote char - string - required
    forceColumnNames:   To force the column name (can be empty) - string - required
    mqlAction:   The MQL action to execut on each line - string - required
admin
csv parse (mql "T") (mql "/Users/jimmitry/Desktop/file.csv") (mql ",") (mql "'") (mql "A,B,C") { log trace [T_A]; };
mentdb
start: 2026-02-02   end: 2026-02-02   v_start: 401   v_end: