Hello, in a form  I have a 'historical' text field allowing multiple
values and using the Newline as separator values. This field is
maintained by the 'querysave'  of the document with those
statements:
'Update edit history
        hist = source.FieldGetText("reserve2")
        hist = hist & Chr$(10) & Chr$(13) & Now & " " &
session.CommonUserName & " Modified/Processed this doc "
        Call source.FieldSetText ("reserve2", hist)
'End of edit history
..
Now I have a request to create a new view and to split this field in
columns.
1 column by save operation.
Knowing that we can have a maximum of 8 save operations during the
process of the document, how can I do that?
I've tried with @word but I never been able to handle the
'historical'
field correctly.
Thanks for your help.
GR

Georges <georges.robert@gmail.com> writes:

> Now I have a request to create a new view and to split this field in
> columns.
> 1 column by save operation.
> Knowing that we can have a maximum of 8 save operations during the
> process of the document, how can I do that?
> I've tried with @word but I never been able to handle the
> 'historical'
> field correctly.

The @subset formula should work for this. The first column would be
@subset(hist; 1), the second @subset(@subset(hist;2);-1) and so on.

Regards
Joerg