CSV 2 Table formatter:Wikka

Revision [23713]

This is an old revision of PLG-Csv made by ThePLG on 2019-09-03 07:41:44.

CSV 2 Table formatter

Features

Rows of the table alternate background color

Column alignment: left, right, center or default

Table headers/footers using wiki style heading markers

Add comments in between data by starting a line with (#); blank lines are ignored

Cells can be surrounded in double quotes (")

It is possible to escape semi-colons with a backslash (\), that should appear in text

Camel links in cell text are linked to their wiki internal pages

`%%(csv)`
`;`	`==/First Name/==;`	`==\Last Name\==;`	`==\|Address\|==;`	`== Age ==`
`==Norwegian==;`	`Sigurd;`	`Nordmo;`	`[[Viggo]] Hansteens allé 119\; 1524 MOSS;`	`38`
`==Swede==;`	`Chanelle;`	`Blomqvist;`	`Överhogdal 95; 282 02 HÖRJA;`	`61`
`==German==;`	`Leah;`	`Ackermann;`	`Landhausstraße 73; 15702 Königs Wusterhausen;`	`25`
`# Comments are possible. Yes, the following person is a Hobbit!`
`==Hobbit==;`	`Celendine;`	`"Gam gee";`	`;`	`216`
`%%`

	First Name	Last Name	Address	Age
Norwegian	Sigurd	Nordmo	[[Viggo]] Hansteens allé 119; 1524 MOSS	38
Swede	Chanelle	Blomqvist	Överhogdal 95; 282 02 HÖRJA	61
German	Leah	Ackermann	"Landhausstraße 73; 15702 Königs Wusterhausen"	25
Hobbit	Celendine	"Gam gee"		216

Would give this as result:

	a	b	c
1	d	e	f
2	g		h
3	I	J	K

Installation

Copy the code below into a file named formatters/csv.php

And give it the same file permissions as the other files in that directory.

<?php
// convert inline csv data into a table.
// by OnegWR, may 2005, license GPL
$csv_printheader=0;
foreach(split("\n", $text) as $csv_n => $csv_line){
if(preg_match("/^#|^\s*$/",$csv_line)) continue;
if( $csv_printheader == 0){ print "<table cellpadding=\"5\" cellspacing=\"1\"><tbody>\n"; $csv_printheader=1; }
print ($csv_n%2) ? "<tr bgcolor=\"#ffffee\">" : "<tr bgcolor=\"#eeeeee\">";
foreach(split(";", $csv_line) as $csv_nn => $csv_cell){
if(preg_match("/^\s*$/",$csv_cell)){
print "<td> </td>";
}elseif(preg_match("/^(\"?)\*\*\*(.*?)\*\*\*(\"?)$/",$csv_cell,$matches)){
print "<td bgcolor=\"#cccccc\">".
$this->htmlspecialchars_ent($matches[2])."</td>";
}elseif(preg_match("/^(\"?)(.*?)(\"?)$/",$csv_cell,$matches)){
print "<td>".$this->htmlspecialchars_ent($matches[2])."</td>";
}else{
print "<td>".$this->htmlspecialchars_ent($csv_cell)."</td>";
}
}
print "</tr>\n";
}
if( $csv_printheader == 1) print "</tbody></table>\n";
?>

History

2005-05-09 Published on main site - OnegWR

2019-09-03 Code clean-up, remove deprecated code, more features, fix bugs - ThePLG

TODO

text in quotes needs to be preserved e.g., whitespace, no splitting on semi-colons

camel links are really hard to see

Add more cell formatting options: alignment, bold, italic, ...

Find a way to implement a "\n" in a cell (every call to $this->Format() is another include of formatters/wakka.php, so I would like to find another way...)

Use more CSS classes

CategoryUserContributions

Wikka : PLG-Csv

Revision [23713]