Splitting a Name 1

[Kivairu]

I have a report with the following kind of headings.

"Tuition - Computer Fee"
"Interest Income"

I want to be left with "Tuition" and "Interest Income" as the heading but when I put the formula.

split({yourfield}, "-")[1]

It gives an error "A subscript must be between 1 and the size of the Array

 

[lbass]

Your formula would return the sample values you show above, so I think you must have a null somewhere. Try this:

if isnull({table.field}) then
"Unknown" else //or ""
trim(split({table.field}, "-")[1])

Trim() will remove extra spaces.

-LB