ntg-context - mailing list for ConTeXt users
 help / color / mirror / Atom feed
From: "Jan U. Hasecke" <juh+ntg-context@mailbox.org>
To: mailing list for ConTeXt users <ntg-context@ntg.nl>
Subject: splitting tables from csv with first row as header
Date: Wed, 23 Jun 2021 16:07:08 +0200	[thread overview]
Message-ID: <24d7b506-e54d-5b92-8926-094f4b7fa488@mailbox.org> (raw)

[-- Attachment #1: Type: text/plain, Size: 501 bytes --]

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

[-- Attachment #2: test.csv --]
[-- Type: text/csv, Size: 654 bytes --]

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

[-- Attachment #3: Type: text/plain, Size: 493 bytes --]

___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://context.aanhet.net
archive  : https://bitbucket.org/phg/context-mirror/commits/
wiki     : http://contextgarden.net
___________________________________________________________________________________

                 reply	other threads:[~2021-06-23 14:07 UTC|newest]

Thread overview: [no followups] expand[flat|nested]  mbox.gz  Atom feed

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=24d7b506-e54d-5b92-8926-094f4b7fa488@mailbox.org \
    --to=juh+ntg-context@mailbox.org \
    --cc=ntg-context@ntg.nl \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for NNTP newsgroup(s).