How do I extract a portion from a list

Two part question. This is my first time with Designer 6.

  1. If I design in 6, will I be able to implement the appplication in NOTES 5.

  2. I am work with a list from a view. I need to extract certain portions from the list. Does anyone know how to do this.

Subject: How do I extract a portion from a list.

  1. The application will fail if you use some features specific to release 6

  2. To extract portions from a list you can use the @Subset function; this function extract some consecutive values from a list beginning from a specified position. See the designer’s help database for more information (look for the chapter “Working with lists”)

Subject: RE: How do I extract a portion from a list.

Javier, Do you know if it’s going to fail if I use the @for and @while?

@Subset was my in my original formula, but I would not know what specific position to start in. What I’m, trying to say is that the info i would need is in various positions.

Subject: RE: How do I extract a portion from a list.

Looping in Formaula Language (@For, @While) are new to Release 6.

FYI - In the Designer help, simply loko for this:

“Note This @function is new with Release 6.” near the top of any command reference.

Subject: Give us more of an example i.e. what is in the list and what is the logic you use to extract.

Subject: RE: Give us more of an example i.e. what is in the list and what is the logic you use to extract.

The contains in the column are dates. for example. Jan 8, 2003; Jan 8, 2003;Jan 8, 2003; Jan 9, 2003; Jan 13, 2003; Jan 8, 2003; Jan 10, 2003;Jan 8, 2003; Feb 10, 2003; Feb 11, 2003 Jan 8, 2003;.

What I want to do is read the field with the dates and collect certain dates. like all the Jan 8 2003 into another field. Would any one know how to do this or have an examples.

Subject: use @keywords

Subject: Try something like this.

C1 := @Text(@DbColumn(…));D1 := @Text(@Today);

C1WithoutToday := @Trim(@Replace(C1; D1; “”));

C1WithOnlyTodays := @Trim(@Replace(C1; C1WithoutToday; “”));

FIELD OnlyTodays := @TextToTime(C1WithOnlyTodays);