Revision history for FormatterCSV


Revision [2549]

Last edited on 2020-04-21 18:18:45 by ThePLG [remove extra bullet]
Additions:
~- Cells can be surrounded in double quotes ("); text in quotes is preserved e.g., whitespace, no splitting on the separator
Deletions:
~- Cells can be surrounded in double quotes (")
~- Text in quotes is preserved e.g., whitespace, no splitting on the separator

Revision [2546]

Edited on 2020-04-21 17:46:14 by ThePLG [Add see also]
Additions:
~- [[SyntaxHighlighter | Code blocks]]
~- [[FormattingRules | Formatting rules]]
Deletions:
~-[[SyntaxHighlighter | Code blocks]]

Revision [2543]

Edited on 2020-04-20 20:23:27 by ThePLG [remove PLG]
Additions:
~- Sept-2019 Code clean-up, remove deprecated code, more features, fix bugs
Deletions:
~- Sept-2019 Code clean-up, remove deprecated code, more features, fix bugs - ThePLG

Revision [2542]

Edited on 2020-04-20 20:21:22 by ThePLG [typo]
Additions:
~- Text in quotes is preserved e.g., whitespace, no splitting on the separator
Deletions:
~- Text in quotes is preserved e.g., whitespace, no splitting on semi-colons

Revision [2541]

Edited on 2020-04-20 20:20:22 by ThePLG [Add source.]
Additions:
||(x:5){border: 0px solid white;}##""%%(csv)""##||
||(x:5){border: 0px solid white;}## #! semi-colon ##||
||(x:5){border: 0px solid white;}## #! th {background-color:#ccc;} ##||
||(x:5){border: 0px solid white;}## #! tr { background-color-even: #ffffee; background-color-odd: #eeeeee; } ##||
||(x:5){border: 0px solid white;}## #! td { background-color-error: #d30; } ##||
||{border: 0px solid white;}##"";""##||{border: 0px solid white;}##""==/First Name/==;""##||{border: 0px solid white;}##""==\Last Name\==;""##||{border: 0px solid white;}##""==|Address|==;""##||{border: 0px solid white;}##""== Age ==""##||
||{border: 0px solid white;}##""==Norwegian==;""##||{border: 0px solid white;}##""Sigurd;""##||{border: 0px solid white;}##""Nordmo;""##||{border: 0px solid white;}##""[[Viggo]],\, Hansteens allé 119\; 1524 MOSS;""##||{border: 0px solid white;}##"" 38""##||
||{border: 0px solid white;}##""==Swede==;""##||{border: 0px solid white;}##"" Chanelle;""##||{border: 0px solid white;}##"" Blomqvist;""##||{border: 0px solid white;}##"" Överhogdal 95\; 282 02 HÖRJA;""##||{border: 0px solid white;}##"" 61""##||
||{border: 0px solid white;}##""==German==;""##||{border: 0px solid white;}##"" Leah;""##||{border: 0px solid white;}##"" Ackermann;""##||{border: 0px solid white;}##"" "Landhausstraße 73; 15702 Königs Wusterhausen";""##||{border: 0px solid white;}##"" 25""##||
||(x:5){border: 0px solid white;}##""# Comments are possible. Yes, the following person is a Hobbit!""##||
||{border: 0px solid white;}##""==Hobbit==;""##||{border: 0px solid white;}##""Celendine;""##||{border: 0px solid white;}##"" "Gam gee";""##||{border: 0px solid white;}##"" ;""##||{border: 0px solid white;}##"" 216""##||
||{border: 0px solid white;}##""%%""##||
Deletions:
||{border: 0px solid white;}##""%%(csv)""##||

Revision [2540]

Edited on 2020-04-20 20:08:16 by ThePLG [docs wikki is on 1.4.2, add native csv table.]
Additions:
|!|{border: 0px solid white;}||
||{border: 0px solid white;}##""%%(csv)""##||
%%(csv)
#! semi-colon
#! th {background-color:#ccc;}
#! tr { background-color-even: #ffffee; background-color-odd: #eeeeee; }
#! td { background-color-error: #d30; }
; ==/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
%%
Deletions:
""<table><tbody>
<tr style="background-color:#eeeeee; "><td style="padding: 1px 10px 1px 10px; "> </td><th style="background-color:#ccc; padding: 1px 10px 1px 10px; text-align:right; ">First Name</th><th style="background-color:#ccc; padding: 1px 10px 1px 10px; text-align:left; ">Last Name</th><th style="background-color:#ccc; padding: 1px 10px 1px 10px; text-align:center; ">Address</th><th style="background-color:#ccc; padding: 1px 10px 1px 10px; "> Age </th></tr>
<tr style="background-color:#ffffee; "><th style="background-color:#ccc; padding: 1px 10px 1px 10px; ">Norwegian</th><td style="padding: 1px 10px 1px 10px; text-align:right; ">Sigurd</td><td style="padding: 1px 10px 1px 10px; text-align:left; ">Nordmo</td><td style="padding: 1px 10px 1px 10px; text-align:center; ">Viggo,\, Hansteens allé 119; 1524 MOSS</td><td style="padding: 1px 10px 1px 10px; ">38</td></tr>
<tr style="background-color:#eeeeee; "><th style="background-color:#ccc; padding: 1px 10px 1px 10px; ">Swede</th><td style="padding: 1px 10px 1px 10px; text-align:right; ">Chanelle</td><td style="padding: 1px 10px 1px 10px; text-align:left; ">Blomqvist</td><td style="padding: 1px 10px 1px 10px; text-align:center; ">Överhogdal 95; 282 02 HÖRJA</td><td style="padding: 1px 10px 1px 10px; ">61</td></tr>
<tr style="background-color:#ffffee; "><th style="background-color:#ccc; padding: 1px 10px 1px 10px; ">German</th><td style="padding: 1px 10px 1px 10px; text-align:right; ">Leah</td><td style="padding: 1px 10px 1px 10px; text-align:left; ">Ackermann</td><td style="white-space:pre; padding: 1px 10px 1px 10px; text-align:center; ">Landhausstraße 73; 15702 Königs, Wusterhausen</td><td style="padding: 1px 10px 1px 10px; ">25</td></tr>
<tr style="background-color:#eeeeee; "><th style="background-color:#ccc; padding: 1px 10px 1px 10px; ">Hobbit</th><td style="padding: 1px 10px 1px 10px; text-align:right; ">Celendine</td><td style="white-space:pre; padding: 1px 10px 1px 10px; text-align:left; ">Gam gee</td><td style="white-space:pre; padding: 1px 10px 1px 10px; text-align:center; "> </td><td style="padding: 1px 10px 1px 10px; ">216</td></tr>
</tbody></table>""

Revision [2539]

Edited on 2020-04-20 19:58:13 by ThePLG [Add title and See also]
Additions:
=====CSV formatter=====
>>==See also==
~-[[SyntaxHighlighter | Code blocks]]
>>{{since version="1.4.2" align="left"}}
Deletions:
{{since version="1.4.2" align="left"}}

Revision [2538]

Edited on 2020-04-20 19:56:35 by ThePLG [Add version number]
Additions:
{{since version="1.4.2" align="left"}}

Revision [2537]

Edited on 2020-04-20 19:50:29 by ThePLG [Add table]
Additions:
""<table><tbody>
<tr style="background-color:#eeeeee; "><td style="padding: 1px 10px 1px 10px; "> </td><th style="background-color:#ccc; padding: 1px 10px 1px 10px; text-align:right; ">First Name</th><th style="background-color:#ccc; padding: 1px 10px 1px 10px; text-align:left; ">Last Name</th><th style="background-color:#ccc; padding: 1px 10px 1px 10px; text-align:center; ">Address</th><th style="background-color:#ccc; padding: 1px 10px 1px 10px; "> Age </th></tr>
<tr style="background-color:#ffffee; "><th style="background-color:#ccc; padding: 1px 10px 1px 10px; ">Norwegian</th><td style="padding: 1px 10px 1px 10px; text-align:right; ">Sigurd</td><td style="padding: 1px 10px 1px 10px; text-align:left; ">Nordmo</td><td style="padding: 1px 10px 1px 10px; text-align:center; ">Viggo,\, Hansteens allé 119; 1524 MOSS</td><td style="padding: 1px 10px 1px 10px; ">38</td></tr>
<tr style="background-color:#eeeeee; "><th style="background-color:#ccc; padding: 1px 10px 1px 10px; ">Swede</th><td style="padding: 1px 10px 1px 10px; text-align:right; ">Chanelle</td><td style="padding: 1px 10px 1px 10px; text-align:left; ">Blomqvist</td><td style="padding: 1px 10px 1px 10px; text-align:center; ">Överhogdal 95; 282 02 HÖRJA</td><td style="padding: 1px 10px 1px 10px; ">61</td></tr>
<tr style="background-color:#ffffee; "><th style="background-color:#ccc; padding: 1px 10px 1px 10px; ">German</th><td style="padding: 1px 10px 1px 10px; text-align:right; ">Leah</td><td style="padding: 1px 10px 1px 10px; text-align:left; ">Ackermann</td><td style="white-space:pre; padding: 1px 10px 1px 10px; text-align:center; ">Landhausstraße 73; 15702 Königs, Wusterhausen</td><td style="padding: 1px 10px 1px 10px; ">25</td></tr>
<tr style="background-color:#eeeeee; "><th style="background-color:#ccc; padding: 1px 10px 1px 10px; ">Hobbit</th><td style="padding: 1px 10px 1px 10px; text-align:right; ">Celendine</td><td style="white-space:pre; padding: 1px 10px 1px 10px; text-align:left; ">Gam gee</td><td style="white-space:pre; padding: 1px 10px 1px 10px; text-align:center; "> </td><td style="padding: 1px 10px 1px 10px; ">216</td></tr>
</tbody></table>""
Deletions:
==Code==
%%(php)
%%

Revision [2533]

Edited on 2020-04-20 19:32:46 by ThePLG [Update some old info.]
Additions:
~- Supports both comma and semi-colon as separator
~- It is possible to escape a separator with a backslash (\), that should appear in text
Deletions:
~- It is possible to escape semi-colons with a backslash (\), that should appear in text
==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.

Revision [2532]

The oldest known version of this page was created on 2020-04-20 19:29:32 by ThePLG [Update some old info.]
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki