Separate field contents into different fields

[meerestier]

Hi,

I have a field, that contains multiple lines (i.e. paragraphs)...

Now I want to separate each line into another field,

field content:

paragraph1

paragraph2

paragraph3

now I want:

field1 content: paragraph1

field2 content: paragraph2

field3 content: paragraph3

(The number of paragraphs varies in every database entry)

How could i achieve this?

Cheers

Lars

[R2D2]

And if someone could also explain, how I can extract Check box -choices to separete fields.

For example:

Check box choices:

X Red

X Green

Yellow

X Blue

to

field1 content: Red

field2 content: Blue

field3 content: Green

So Yellow is not selected and thus not extracted.

I think basically the technique is about the same. Or is it ?

[Søren Dyhr]

Pretty straight forward, here is the calc'field getting a value if the 3rd value in the valuelist is chosen:

FilterValues ( the_checkboxes ; GetValue ( ValueListItems ( Get ( FileName ) ; "theList" ) ; 3 ) )

--sd

split.zip

[R2D2]

Ok. I have to try that tomorrow...

Tack so mycket !