Tags:
create new tag
, view all tags

Question

Can one extract selected columns from a table to automatically construct a second table. A pointer to an example will suffice. More specifically, given

Col1 Col2 Col3
cat black Cinder
dog brown Dusty

automatically generate this table, which is a subset (only) of the above:

Col1 Col3
cat Cinder
dog Dusty

By the by, we've adopted twiki for our corporate intranet. Great technology. Thanks for it.

Jared Freeman freeman@aptimaPLEASENOSPAM.com

Environment

TWiki version: TWikiRelease04x00x00
TWiki plugins: DefaultPlugin, EmptyPlugin, InterwikiPlugin
Server OS:  
Web server:  
Perl version:  
Client OS:  
Web Browser:  
Categories: Forms, Search, Missing functionality, Plugins, Add-Ons

-- JaredFreeman - 02 Mar 2006

Answer

ALERT! If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list below the edit box.

Do a multiple="on" search on the topic to get at the table rows, then apply regular expression patterns to pull out what you need. Here is an example (view raw to see how):

Col1 Col3
cat Cinder
dog Dusty

For complex data structures it might be better to use TWikiForms based applications with FormattedSearch reports.

BTW, if you have a successfull TWiki deployment, how about contributing a TWiki successfull story? Follow the links in the TWiki home page.

-- PeterThoeny - 02 Mar 2006

cat Cinder
cat
Categories:

Col1 Col2 Col3
Col1 Col2 Col3
Col1 Col2 Col3
Col1 Col2 Col3
Col1 Col2 Col3
Col1 Col2 Col3

-- JaredFreeman

 
Topic revision: r4 - 2006-03-07 - PeterThoeny
 
Twitter Delicious Facebook Digg Google Bookmarks E-mail LinkedIn Reddit StumbleUpon    
  • Download TWiki
TWiki logo Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2012 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.