Removing the symbol from a Business Objects query

[FryGirl]

I've searched the net to see if I can find a solution to this and the best I can come up with is = Replace([Name],">"," ")

I can easily do this in Excel, but I was hoping to do the source, BO.

.Range("B:B").Replace ">", " ", xlPart, , False, , False, False

In Business Objects the field look like the below. Every word has a ">" sign before it and for every ">", simply replace it with a space equal to the number of ">" signs.

>Washington
>>Franklin
>>>Jefferson

Anybody have a thought or experience with BO?

 

[FryGirl]

Fixed: In BO, comma's need to be semi-colons.