user defined function using Array

[Dennisli2000]

Good afternoon,
I have the following user defined function using Array function but it did not work.
Any ideas will be highly appreciated.
Dennis

Please Login or Register  to view this content.

[T-J]

Don't you need to search through each array in turn? Example for BIArray:

Please Login or Register  to view this content.

[Dennisli2000]

thank you.
Actually I complexize the question which can be simplified as the following example:

Case "PI ", "PI", "PIP TRAN", " PIP", " PIP", " PIP": Cov="PIP"

thanks again the forum.
Dennis

[MrShorty]

"didn't work" is such a general statement. Can you elaborate? What didn't work? Did it give an error message? What would be a typical value for "prefix"? For a given value of "prefix", what do you expect returned? If it's returning the wrong value, what value is it returning?