Search Result: '│' - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

Documentation DuckDB 1.3 ドキュメント全文検索

DuckDB 1.3 ドキュメント全文検索

Results of 1 - 1 of about 1 for '│' (0.003 sec.)

Importing Duckbox Tables – DuckDB 9414: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... follows: a│b hello│42 world│84 We can then simply load this to DuckDB via: FROM read_csv ( 'duckbox-cleaned.csv' , delim = '│' ); And export it to a CSV: COPY ( FROM read_csv ( 'duckbox-cleaned.csv' , delim = '│' )) TO 'out.csv' ; a,b hello,42 world ... /^│ *//;s/ *│$//;s/ *│ */│/p;2q" duckbox.csv; ' || 'sed "1,4d;\$d;s/^│ *//;s/ *│$//;s/ *│ */│/g" duckbox.csv) |' , delim = '│' ); We can also create a table macro : CREATE MACRO read_duckbox ( path ) AS TABLE FROM read_csv ( printf ( '(sed -n "2s/^│ ... *//;s/ *│$//;s/ *│ */│/p;2q" %s; ' || 'sed "1,4d;\$d;s/^│ *//;s/ *│$//;s/ *│ */│/g" %s) |' , path , path ), delim = '│' ); Then, reading a duckbox table is as simple as: FROM read_duckbox ( 'duckbox.csv' ); shellfs is a community extension an ...; https://man.mtool.work/duckdb/1.3/guides/snippets/importing_duckbox_tables.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work