[Download-List] FW: Download question regarding the use of EVAL with a multi-valued field.

[George W Ohlandt]

Maggie,

  Try INDEX with multi-valued fields instead of LIKE

DOWNLOAD STUDENTS @ID N12.FRUIT NUM.VALUES 5 EVAL "IF INDEX(N12.FRUIT,'APPLES',1) THEN 'APPLES' ELSE ''" EVAL "IF INDEX(N12.FRUIT,'ORANGES',1) THEN 'ORANGES' ELSE ''"

George

George W. Ohlandt
Director for Admissions
Office of Enrollment Management
Medical University of South Carolina
843.792.3813
ohlandtg at musc.edu

--On Friday, September 16, 2005 12:28 PM -0400 Maggie Steyn <msteyn at niagara.edu> wrote:

>
>
>
> I didn't receive any feedback from anyone when I sent this earlier, so am re-broadcasting this. I would appreciate
> any suggestions.
>
> I am trying to 'sort' the order of the values in a multi-valued field so that all of the 'APPLES' values will be in one column, all of the 'ORANGES' values in the next etc. (The Fruit values, of
> which I can have up to 5, could have been loaded into the STUDENTS file in the multi-valued field in any sequence.)
>
> DOWNLOAD STUDENTS @ID N12.FRUIT NUM.VALUES 5 EVAL "IF N12.FRUIT LIKE '...APPLES...' THEN 'APPLES' ELSE ' '" EVAL "IF N12.FRUIT LIKE '...ORANGES...' THEN 'ORANGES' ELSE ' '"      ....etc
>
> I am not getting any values returned in my EVAL fields. (I've tried exchanging LIKE for EQ & removing the ' ...'s but the results are the same.)
>
> Is EVAL on a multi-valued field supported in DOWNLOAD ?
>
> Thank you for your help.
>
> (We are using Download Version 7.11.)
>
> Maggie Steyn
> Application Analyst
> Information Technology Department
> Niagara University
> msteyn at niagara.edu
> Phone: (716) 286-8651
> Fax: (716) 286-8045
>
>