Split one field into two using a character symbol

[irishmick]

I am looking for help with a formula. Our program contains a description field which will contain desc such as "00100 - Torch". Our existing report contains one desc field showing the full desc. I need to be able to split this field into two seperate fields for Code and Description. The constant seperator will always be the - symbol.

Any help appreciated?.

 

[lbass]

//{@first element}:
split({table.field}," - ")[1]

//{@second element}:
if ubound(split({table.field}," - ")) >= 2 then
split({table.field}," - ")[2]

-LB