CSV File Search Viewer(by SQL and keyword)

Puoi usarlo come visualizzatore di file CSV, cercare per SQLite SQL o colonne per parola chiave

You can use as a CSV file viewer, and you can search by SQLite SQL statements or specific columns by keyword and display the required rows and columns.

[Specifications]

-Importing a CSV file in the device will automatically create a sqlite table (the row content will automatically determine the table type as TEXT or Integer) and query screen.

-The SQL table name is csv_table, and the column names are a1, a2, a3 ... from the first column. You can search CSV files like this,

query For example: select * from csv_table where a1 = "123" and a3> = "5000"

-For those who do not understand SQL, you can search from the "Advanced Search" screen,

For string columns:"contains(like)" and "equal (=") etc,

For numeric columns:"greater than or equal to (> =)" and "smaller(<)" etc.

-The selected CSV file can be confirmed only on the installed device and will not be accessed from the outside.

[CSV file rules]

-The header (first line) is required.

-If there is a tab in the header (1st line), the "delimiter" of the CSV file will automatically become a tab. If there is no tab, the delimiter will be ,(comma).

-The enclosing character is double quotation (") or none.

-Lines that do not match the number of headers will be skipped.