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
--
JaredFreeman - 02 Mar 2006
Answer
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