From mboxrd@z Thu Jan 1 00:00:00 1970 X-Msuck: nntp://news.gmane.io/gmane.comp.tex.context/111867 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: "Jan U. Hasecke" Newsgroups: gmane.comp.tex.context Subject: splitting tables from csv with first row as header Date: Wed, 23 Jun 2021 16:07:08 +0200 Message-ID: <24d7b506-e54d-5b92-8926-094f4b7fa488@mailbox.org> Reply-To: mailing list for ConTeXt users Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="------------66CEB772431E1D720C49048F" Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="38929"; mail-complaints-to="usenet@ciao.gmane.io" To: mailing list for ConTeXt users Original-X-From: ntg-context-bounces@ntg.nl Wed Jun 23 16:07:56 2021 Return-path: Envelope-to: gctc-ntg-context-518@m.gmane-mx.org Original-Received: from zapf.boekplan.nl ([5.39.185.232] helo=zapf.ntg.nl) by ciao.gmane.io with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lw3Xo-0009x5-Bc for gctc-ntg-context-518@m.gmane-mx.org; Wed, 23 Jun 2021 16:07:56 +0200 Original-Received: from localhost (localhost [127.0.0.1]) by zapf.ntg.nl (Postfix) with ESMTP id 94E78284B29; Wed, 23 Jun 2021 16:07:17 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at zapf.boekplan.nl Original-Received: from zapf.ntg.nl ([127.0.0.1]) by localhost (zapf.ntg.nl [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Y6WRG5FoNjvW; Wed, 23 Jun 2021 16:07:16 +0200 (CEST) Original-Received: from zapf.ntg.nl (localhost [127.0.0.1]) by zapf.ntg.nl (Postfix) with ESMTP id 817E7284B11; Wed, 23 Jun 2021 16:07:16 +0200 (CEST) Original-Received: from localhost (localhost [127.0.0.1]) by zapf.ntg.nl (Postfix) with ESMTP id 5FB7D284B11 for ; Wed, 23 Jun 2021 16:07:14 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at zapf.boekplan.nl Original-Received: from zapf.ntg.nl ([127.0.0.1]) by localhost (zapf.ntg.nl [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id KuYalpPpdegH for ; Wed, 23 Jun 2021 16:07:13 +0200 (CEST) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=80.241.56.151; helo=mout-p-101.mailbox.org; envelope-from=juh+ntg-context@mailbox.org; receiver= Original-Received: from mout-p-101.mailbox.org (mout-p-101.mailbox.org [80.241.56.151]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) (No client certificate requested) by zapf.ntg.nl (Postfix) with ESMTPS id 600E72839F6 for ; Wed, 23 Jun 2021 16:07:13 +0200 (CEST) Original-Received: from smtp2.mailbox.org (smtp2.mailbox.org [80.241.60.241]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-p-101.mailbox.org (Postfix) with ESMTPS id 4G94p86RKkzQk2K for ; Wed, 23 Jun 2021 16:07:12 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=mailbox.org; h= content-language:content-type:content-type:mime-version:date :date:message-id:subject:subject:from:from:received; s= mail20150812; t=1624457229; bh=Ey3KDGVTMP1jYk2FxH2GuPQ7e7eoJ/blx apkXMRVai8=; b=gjNMTT0quB8rgV+BgLM6aVziGvR/5TtzWmosf0MK7CZc+ZpPn oIqCGIT40eyuNJUXJCBkg9eaZ8l5ZCruu32/dvvCUl2J+ZGtIiXjNpGwo9LFjvXD F6nS92LyoMXecDoPWiIGZEDQP2kfHLOAdoodVKLA2E8iZ/08gngMOWk6CELEstN2 zbkk0mQx/swsXzpRTB617qYuaFHEq4XcfxrtF9JDTbU+i8cgGOqf1jIGzFtfBDJ+ vTtLndRP+XLq4CRBpYlZD48A58eoHGypQZBmcVpVnBkrka1JtA+l7o4Fj5p4NH2z idahLQv1dpaBJT9Z0DojqvhQPh+O0LeTbI05g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mailbox.org; s=mail20150812; t=1624457230; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type; bh=JfCP4y/xMTKUgFBDrXemNTXwrlGpTEofFUiwuB2zgSU=; b=HtplC4hZ5M9is6seU3dH7l/XvRzKi8WTwDQXGuWZugzziptbmE0GQJrDg5Li2E07SHMwc0 DNGa5I/2YiGb/cBeaQJzxQTxhmUzO1O73Pq1Z4DtQ8b7nUVhMQpjpsHhp5GVzXRivhSzjV H2kdALuYJP19w45DAMpWLGXi5qQrHOXuOB8aR2FQMkllTgrKZB3iF/gmPZABP5lloiDjfk VsPTITr65SM9ZbGnibPAPLqRIJ4odrn+2eobzN0PyWTQZnIvDcksKnW+EjeXBbhl3Lp8as Ht0HgUZq4kMENFVtALZxoRZjm0HOWWY3RLuzz0RjIlVHwyx2jrXn04in5YNy5w== X-Virus-Scanned: amavisd-new at heinlein-support.de Original-Received: from smtp2.mailbox.org ([80.241.60.241]) by spamfilter02.heinlein-hosting.de (spamfilter02.heinlein-hosting.de [80.241.56.116]) (amavisd-new, port 10030) with ESMTP id sjmJTa8UFhcV for ; Wed, 23 Jun 2021 16:07:09 +0200 (CEST) Content-Language: en-US X-Rspamd-Score: -1.69 / 15.00 / 15.00 X-Rspamd-Queue-Id: D0BE91819 X-Rspamd-UID: e688da X-BeenThere: ntg-context@ntg.nl X-Mailman-Version: 2.1.26 Precedence: list List-Id: mailing list for ConTeXt users List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: ntg-context-bounces@ntg.nl Original-Sender: "ntg-context" Xref: news.gmane.io gmane.comp.tex.context:111867 Archived-At: This is a multi-part message in MIME format. --------------66CEB772431E1D720C49048F Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Hi all, I have this sample: \usemodule[database] \setuppapersize [A6] \setupTABLE [split=yes, header=repeat] \defineseparatedlist [test] [separator={;}, % tab before=\bTABLE,after=\eTABLE, first=\bTR,last=\eTR, left=\bTD,right=\eTD] \starttext \processdatabasefile[test][test.csv] \stoptext A test.csv is attached. The table splits but no header is repeated. I guess I have to define that the first row in the file is the header. How to achieve this? TIA juh --------------66CEB772431E1D720C49048F Content-Type: text/csv; charset=UTF-8; name="test.csv" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="test.csv" A;B;C;D;E;F 1;2;3;4;5;6 2;3;4;5;6;7 3;4;5;6;7;8 4;5;6;7;8;9 5;6;7;8;9;10 6;7;8;9;10;11 7;8;9;10;11;12 8;9;10;11;12;13 9;10;11;12;13;14 10;11;12;13;14;15 11;12;13;14;15;16 12;13;14;15;16;17 13;14;15;16;17;18 14;15;16;17;18;19 15;16;17;18;19;20 16;17;18;19;20;21 17;18;19;20;21;22 18;19;20;21;22;23 19;20;21;22;23;24 20;21;22;23;24;25 21;22;23;24;25;26 4;5;6;7;8;9 5;6;7;8;9;10 6;7;8;9;10;11 7;8;9;10;11;12 8;9;10;11;12;13 9;10;11;12;13;14 10;11;12;13;14;15 11;12;13;14;15;16 12;13;14;15;16;17 13;14;15;16;17;18 14;15;16;17;18;19 15;16;17;18;19;20 16;17;18;19;20;21 17;18;19;20;21;22 18;19;20;21;22;23 19;20;21;22;23;24 20;21;22;23;24;25 21;22;23;24;25;26 --------------66CEB772431E1D720C49048F Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: inline X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX18KSWYgeW91ciBxdWVzdGlvbiBpcyBvZiBpbnRlcmVz dCB0byBvdGhlcnMgYXMgd2VsbCwgcGxlYXNlIGFkZCBhbiBlbnRyeSB0byB0aGUgV2lraSEKCm1h aWxsaXN0IDogbnRnLWNvbnRleHRAbnRnLm5sIC8gaHR0cDovL3d3dy5udGcubmwvbWFpbG1hbi9s aXN0aW5mby9udGctY29udGV4dAp3ZWJwYWdlICA6IGh0dHA6Ly93d3cucHJhZ21hLWFkZS5ubCAv IGh0dHA6Ly9jb250ZXh0LmFhbmhldC5uZXQKYXJjaGl2ZSAgOiBodHRwczovL2JpdGJ1Y2tldC5v cmcvcGhnL2NvbnRleHQtbWlycm9yL2NvbW1pdHMvCndpa2kgICAgIDogaHR0cDovL2NvbnRleHRn YXJkZW4ubmV0Cl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCg== --------------66CEB772431E1D720C49048F--