Split Function Error Message 1

[Steve95]

Hi All

Iam learning about the "Split" function, I used the first 2 examples provided in the help section of CRXi and got an error message "The result of a formula cannot be an array"

syntax used in my formula field:
1. Split ("Chocolate Strawberry Pineapple")
2. Split ("Chocolate//Strawberry//Pineapple", "//")

I find that strange cause I just copied and pasted that example into my formula field for testing and both examples coming with the same error message?

Any ideas?

Many Thanks

 

[dgillz]

What is your desired result? The error message is correct, the result cannot be an array.

Split ("Chocolate Strawberry Pineapple"," ")[1] will return "Chocolate"

Split ("Chocolate Strawberry Pineapple"," ")[2] will return "Strawberry"

etc., etc.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Steve95]

Thanks for getting back to me, but the subscript is not mentioned in the example from CRXi hence my concern at the error message.

Many Thanks

 

[dgillz]

You probably just saw the syntax of the split command which was not taking into account the greater context of not being able to return an array as a formula result.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Steve95]

ANother question out of interest can a split bring back an array of values?