bpj
commented
7 years ago All spreadsheet programs can also export tab separated values (TSV) and those are very easy to convert into Markdown pipe tables using a decent text editor which supports regular expressions and preferably likewise substitutions. The following Perl program "tsv2pipetable.pl" takes a TSV file on stdin, converts it into a pipe table assuming that the first line is a header row and spits out the pipe table on stdout. You can use it as a filter in pp with
!exec(perl tsv2pipetable.pl <filename.tsv)#!/usr/bin/env perl
# tsv2pipetable.pl - convert a file with tab separated values to a Pandoc pipe table
#
# Usage:
#
# perl tsv2pipetable.pl <filename.tsv >pipetable.md
use strict;
use warnings;
use 5.008005
use open qw[ :utf8 :std ];
my $colfill = '-' x 5; # for the column spec row
# slurp all lines into an array
my @rows = <>;
# construct the column spec row
## make a copy of the first line
unshift @rows, $rows[0];
## replace column contents in the colspec row with five dashes each
$rows[1] =~ s/[^\t\n]+/$colfill/g;
# process each row
for ( @rows ) {
## escape existing pipes if any
s/\|/\\|/g;
## replace tabs with pipes
s/\t/|/g;
## insert a pipe at the start of each row
s/^/|/;
}
# join the lines and print the pipetable to stdout
print STDOUT join "", @rows;
__END__I hope this helps. Just ask if something isn't clear!
duzyn
CDSoft
tajmone
It would be nice if pp can include CSV file as markdown table like iA write did.