• Do not register here on develop.twiki.org, login with your twiki.org account.
• Use View topic Item7848 for generic doc work for TWiki-6.1.1. Use View topic Item7851 for doc work on extensions that are not part of a release. More... Close
• Anything you create or change in standard webs (Main, TWiki, Sandbox etc) will be automatically reverted on every SVN update.
Does this site look broken?. Use the LitterTray web for test cases.

Item7718: DataTablePlugin to handle column names containing non-word characters

Item Form Data

AppliesTo: Component: Priority: CurrentState: WaitingFor: TargetRelease ReleasedIn
Extension DataTablePlugin Normal Closed   n/a  

Edit Form Data

Reported By:
Applies To:
Current State:
Waiting For:
Target Release:
Released In:


When you use %DATATBL{...}%, you may not have control over column names of the data source table. So column names may contain non-word characters such as comma (,), period (.), and slash (/). Meanwhile, when you specify column names in the format parameter and specifying search criteria, a column name must start with a letter and consists only of word characters [A-Za-z0-9_].

The gap needs to be filled. So here's the logic to make a column name used in %DATATABL{...}% out of a table's column name

  1. Remove non-word characters at the end of a column name
  2. Replace a consecutive string of non-word characters with a single underscore

For example:

On a table In %DATATBL{...}%
*Abc/Def:* Abc_Def
*Ghi Jkl_* Ghi_Jkl_

-- TWiki:Main/HideyoImazu - 2016-01-21

Summary DataTablePlugin to handle column names containing non-word characters
ReportedBy TWiki:Main.HideyoImazu

SVN Range TWiki-6.0.2-trunk, Sun, 10 Jan 2016, build 29797
AppliesTo Extension
Component DataTablePlugin
Priority Normal
CurrentState Closed

Checkins TWikirev:29914 TWikirev:29915 TWikirev:29916 TWikirev:29947 TWikirev:29948 TWikirev:29949 TWikirev:29964 TWikirev:29965
TargetRelease n/a

Edit | Attach | Watch | Print version | History: r15 < r14 < r13 < r12 < r11 | Backlinks | Raw View |  Raw edit | More topic actions
Topic revision: r15 - 2016-02-16 - PeterThoeny
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback