ValueListItems in a Substitute function

[dknc]

I am having difficulty getting a ValueListItems function to work when used in a Substitute function. With the name of the file I am working in being "billing.fp5" and the value list named "visit_or_procedure", I have tried:

Substitute( ValueListItems( "billing",visit_or_procedure ), "

[SteveB]

Try Substitute( ValueListItems( Status(CurrentFileName)),visit_or_procedure ), "

[dknc]

Thanks, but with that I get a "There are too few separators in this function." message with the parenthesis just before the first comma highlighted.

D

[Fenton]

Substitute( ValueListItems( "billing.fp5", "visit_or_procedure" ), "