Question

Hi - I've researched all over for sample of how to make this work, but am at my wits end.

I am trying to extract a comma-separated list of values from a single table field. The samples in SearchPatternCookbook have gotten me close, but no cigar yet.

The table looks like this:

I want to extract the values "Not Started, Active, Completed" for use in a select box in a form. I'm missing the right search and format regexes for this, I'm pretty sure. Many thanks in advance!

Environment

-- BenSommer - 21 Nov 2008

Answer

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.

Here is a working example that builds a pick list based on the Status definition in above table. Look at the "raw view" to copy it.

On behalf of the friendly TWikiCommunity.

-- PeterThoeny - 21 Nov 2008

Many thanks, Sir! I'll be sure to study this example for future use - looks like there are several nifty, perl-ish utility functions I can use going forward.

-- BenSommer - 22 Nov 2008

Your welcome. TWiki is an application platform, study TWikiVariables, TWikiForms, TWikiTemplates, VarSEARCH, FormattedSearch, QuerySearch, and see sample applications in the Sandbox home page. BTW, call me Peter, it's more informal.

If you are interested we'd love to get you involved in the TWikiCommunity. As a contributor you can actively make a difference. See Codev.ReadmeFirst for core code, and Plugins.ReadmeFirst for extensions.

-- PeterThoeny - 22 Nov 2008