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 someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is 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

Edit | Attach | Watch | Print version | History: r4 < r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r4 - 2006-03-07 - PeterThoeny
 
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2026 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.