Replace Function with an aggregated field

[mgregory24479]

I have a field that is really a concatenation but in Oracle its called aggregate. What we have is multiple values in one field that come across as this:

ABC Company: $50000 // BCE Company: $2000

We created a calculation using this syntax:
replace([GIVINGHISTORYBYALLOCATION],' // ',chr(13)+chr(10))
returning the results of:
ABC Company: $50000
BCE Company: $20000

I want to remove the dollar amounts from both line items. I have tried REPLACE( Column, RIGHT(Column, 3), '' ) but I am getting an error.

Any thoughts?

[sdf]

What is the error you are getting?

as far as I can remember the syntax for replace is :

replace([stringItem], '<what will be replaced>', '<what to replace>')

so for you :

replace([stringItem], '$' , ' ')

cheers!