Un-concat'ing

[#1]

Hi,

I want to create a list box that separates out a field that has comma's as separators.

i.e

Default List Box Values:

Asia, BAU, Regions

Asia, Project, Regions

BAU, Ops

Ops, Project

CD, Project

What I want is the same values, but separately selectable:

Asia

BAU

Project

Regions

Ops

CD

I'm happy to hardcode the list somewhere and to be able to filter on any record that has one or more of the selected values.

Any help would be appreciated.

Thanks

Simon

[tresesco]

Use Subfield() function. Like: Subfield(Fieldname, ',' , 1)

[ThornOfCrowns]

If you're happy to "hardcode" the list, make an Inline Table and use that, perhaps?

[rustyfishbones]

try using the SUBFIELD()

something like

[Peter_Cammaert]

You'ld better do this in your load script because a list box has to refer to some field in your data model.

The SUBFIELD() function has a 2-parameter function that does exactly what you want. It creates a single record for every subfield separated by a specific delimiter.

For instance:

LOAD subfield(ListBoxField, ',') AS SingleValue

RESIDENT ListBoxFieldTable;

will serialize alle values from your example into a list of individual records. A subsequent list box will skip the doubles.

Peter

[rustyfishbones · Accepted solution]

Hi,

Please see the attached file, I hope it helps

[#7]

Brilliant, thanks all! Works a treat.