| |
GeekInterview.com > Interview Questions > Data Warehousing > Reportnet
| Print | |
Question: How do you remove spaces from middle of the name in Reportnet
Answer: In ReportNet, I am trying to remove a space from the name field. What i want is to end up with the following but it doesn't like my syntax: substring([CES Archive: Transactions].[Expense Report Workflow Trail].[Employee Assigned to Step],1,6)
||substring([CES Archive: Transactions].[Expense Report Workflow Trail].[Employee Assigned to Step],8,
(length([CES Archive: Transactions].[Expense Report Workflow Trail].[Employee Assigned to Step])).
Does anyone know what the correct syntax is? thanks |
| February 02, 2008 12:36:49 |
#2 |
| praveenj6 |
Member Since: December 2007 Total Comments: 6 |
RE: How do you remove spaces from middle of the name in Reportnet
|
I dont think so., Ltrim and Rtrim is used to remove spaces on left hand side and r.h.s
but in the middle there functions cannot remove the spaces
|
| |
Back To Question | |
