ValueListItems fun (well, not really)

[Rob 7 Collins]

I have a script tht needs to access items from a value list. For some reason it is not doing that. In my script I have this, to access the value list items:

Substitute ( 

MiddleValues (

ValueListItems ( Get ( FileName ) ; "vlAnyOf" ) ;

GetAsNumber ( RightWords ( Get ( ScriptParameter ) ; 1 ) ) ;

1

) ;

[Rob 7 Collins]

I decided to write up a sample database to post, for this problem. It worked ... turns out it was the filename that was the problem.

The filename for the real file has a period in it. To work around this, you must use: Get (FileName ) & ".fp7"

[Vaughan]

I'd be changing the file names to remove all periods and spaces, rather than adding the extension to the calculation.