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?
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!