Hello All,
I have a value where I need to trim the first 19 characters off in order make it more usable. I am graphing some data and it all starts off "Hold:1 = Line:Sales Real Value" (substitute "Real Value" for the true reason for the hold). I need to get rid of the portion in red in order to get a true value for the chart.
Below is the what I have so far for trim, but I just get an error back. I am sure it is simple, but I am pretty new to this. Thank you in advance.
trim(leading,[OracleCustomObjects].[HYP_DW_BOOK_OPEN_SHIP].[HOLD_REASONS],15)
Kelly
Why not just use the substring function? and in your case, you have to trim 20 characters, not 19 otherwise you will be displaying a blank before the 'Real Value'.
substring([OracleCustomObjects].[HYP_DW_BOOK_OPEN_SHIP].[HOLD_REASONS],20,50)
Replace 50 with the no. of characters you want to be displayed and replace [OracleCustomObjects].[HYP_DW_BOOK_OPEN_SHIP].[HOLD_REASONS] with whatever name you have in Cognos.
Thank you. this worked perfectly. I appreciate you taking the time to explain it to me as well. I have a lot of uses for it.
Kelly